SETIDPrompt Table: SETID_TBL
GPCH_RP_LSESVALPrompt Table: JOBCODE_TBL
GPCH_RP_LSEJC(SQL Table) |
Index Back |
|---|---|
Setup Cross Refer. JobCodeSetup Cross Reference JobCode |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | GPCH_RP_LSESVAL |
Character(8) | VARCHAR2(8) NOT NULL |
Salary Type Value
Prompt Table: JOBCODE_TBL |
| 3 | GPCH_RP_LSETVAL | Number(2,0) | SMALLINT NOT NULL | Activity |