RBQ_QCJOB_TMP(SQL Table) |
Index Back |
|---|---|
Quick Create BC Flag TempQuick Create BC Flag Temporary record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GROUP1 | Character(1) | VARCHAR2(1) NOT NULL | Job Assignment |
| 2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | WORKER_SUBROLE | Character(3) | VARCHAR2(3) NOT NULL |
Worker Sub-Role for Worker' Job Assignment
086=Employee 087=Contingent Worker |
| 4 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SETID_DEPT_VW |
| 5 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL |
Department
Prompt Table: DEPT_TBL_WRK_VW |
| 6 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL |
Location SetID
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SETID_LOCATN_VW |
| 7 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table: LOCATION_WRK_VW |
| 8 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL |
SETID_JOBCODE field used in the HCM/ CRM sync Application Messages.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SETID_JOBCD_VW |
| 9 | JOBCODE | Character(15) | VARCHAR2(15) NOT NULL |
Job Code or Job Title.
Prompt Table: JOBCD_WRK_VW |