HR_VT_SETUP_IDDefault Value: HR_VT_SRCHSETUP.HR_VT_SETUP_ID
EFFDTSETIDPrompt Table: SETID_NOMETA_VW
Prompt Table: HR_VT_JCTREEVW
HR_VT_TREE_JC(SQL Table) |
Index Back |
|---|---|
SP360 Setup - Job Code Trees |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_VT_SETUP_ID |
Character(4) | VARCHAR2(4) NOT NULL |
seed row of HR_VT_SRCHSETUP
Default Value: HR_VT_SRCHSETUP.HR_VT_SETUP_ID |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_NOMETA_VW |
| 4 | HR_VT_JCTREENM | Character(18) | VARCHAR2(18) NOT NULL |
used on Setup Pages for Configurable Dashboard and Progression Chart
Prompt Table: HR_VT_JCTREEVW |