| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SDK_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
SDK Department ID
|
| 2 |
SDK_EFFDT |
Date(10) |
DATE NOT NULL |
SDK Effective Date
Default Value: %date
|
| 3 |
SDK_EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
SDK Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
SDK_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
SDK Description
|
| 5 |
SDK_DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
SDK Short Description
|
| 6 |
SDK_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
SDK Company
Prompt Table:
SDK_COMPANY_TBL
|
| 7 |
SDK_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
SDK Location Code
Prompt Table:
SDK_LOCH_TBL
|
| 8 |
SDK_MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
SDK Manager ID
Prompt Table:
SDK_PERS_DATA
|
| 9 |
SDK_MANAGER_POSN |
Character(8) |
VARCHAR2(8) NOT NULL |
SDK Manager Position
Prompt Table:
SDK_POS_DATA
|
| 10 |
SDK_BUDGET_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
SDK Budget Level
D=Department
J=Job Code
L=Line Item
N=None
P=Position Number
Default Value: N
|
| 11 |
SDK_EEO4_FUNCTION |
Character(2) |
VARCHAR2(2) NOT NULL |
SDK 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
|