TRANSACTION_NAMESS_GRP_IDSS_TRANS_IDSS_PROCESS_CYCLESS_DTL_JOB(SQL Table) |
Index Back |
|---|---|
Self Service Job Temp TableUsed to present Job-related informa |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 2 | SS_GRP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Key Used in SS Framework |
| 3 | SS_TRANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Key Used in SS Framework |
| 4 | SS_PROCESS_CYCLE |
Number(3,0) | SMALLINT NOT NULL | Used in SS Framework |
| 5 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 6 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 7 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 8 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |