JOB_FUNCTIONEFFDTDefault Value: %date
JOB_SUB_FUNCPrompt Table: JOB_SUBFUNC_TBL
JOB_FNC_SUB_TBL(SQL Table) |
Index Back |
|---|---|
SubFunctions for a Job FuncThis table stores all the sub functions associated with a Job Function. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOB_FUNCTION |
Character(3) | VARCHAR2(3) NOT NULL | Job Function Code |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | JOB_SUB_FUNC |
Character(3) | VARCHAR2(3) NOT NULL |
Job sub Function
Prompt Table: JOB_SUBFUNC_TBL |