SDK_DEPT_TBL

index back

SDK Departments

SDK Department Table

PeopleSoft Field NameField TypeColumn TypeDescription
SDK_DEPTIDCharacter(10)VARCHAR2(10) NOT NULLSDK Department ID
SDK_EFFDTDate(10)DATE NOT NULLSDK Effective Date

Default: %date

SDK_EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLSDK Effective Status
A=Active
I=Inactive

Default: A

SDK_DESCRCharacter(30)VARCHAR2(30) NOT NULLSDK Description
SDK_DESCRSHORTCharacter(10)VARCHAR2(10) NOT NULLSDK Short Description
SDK_COMPANYCharacter(3)VARCHAR2(3) NOT NULLSDK Company

Prompt Table: SDK_COMPANY_TBL

SDK_LOCATIONCharacter(10)VARCHAR2(10) NOT NULLSDK Location Code

Prompt Table: SDK_LOCH_TBL

SDK_MANAGER_IDCharacter(11)VARCHAR2(11) NOT NULLSDK Manager ID

Prompt Table: SDK_PERS_DATA

SDK_MANAGER_POSNCharacter(8)VARCHAR2(8) NOT NULLSDK Manager Position

Prompt Table: SDK_POS_DATA

SDK_BUDGET_LVLCharacter(1)VARCHAR2(1) NOT NULLSDK Budget Level
D=Department
J=Job Code
L=Line Item
N=None
P=Position Number

Default: N

SDK_EEO4_FUNCTIONCharacter(2)VARCHAR2(2) NOT NULLSDK U.S. EE04 Function
01=Financial Administration
02=Streets and Highways
03=Public Welfare
04=Police Protection
05=Fire Protection
06=Natural Resources
07=Hospitals & Sanatoriums
08=Health
09=Housing
10=Community Development
11=Corrections
12=Utilities & Transportation
13=Sanitation & Sewage
14=Employment Security
15=Other
99=Not Counted for EEO Reporting
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19