SDK_DEPT_TBL

Return to Index

Table: PS_SDK_DEPT_TBL

SDK Department Table

PeopleSoft Field NameDescription
SDK_DEPTIDSDK Department ID
SDK_EFFDTSDK Effective Date

Default: %date

SDK_EFF_STATUSSDK Effective Status
A=Active (default)
I=Inactive
SDK_DESCRSDK Description
SDK_DESCRSHORTSDK Short Description
SDK_COMPANYSDK Company

Prompt Table: SDK_COMPANY_TBL

SDK_LOCATIONSDK Location Code

Prompt Table: SDK_LOCH_TBL

SDK_MANAGER_IDSDK Manager ID

Prompt Table: SDK_PERS_DATA

SDK_MANAGER_POSNSDK Manager Position

Prompt Table: SDK_POS_DATA

SDK_BUDGET_LVLSDK Budget Level
D=Department
J=Job Code
L=Line Item
N=None (default)
P=Position Number
SDK_EEO4_FUNCTIONSDK 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

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010