GPBR_ES_HIRE_VW(SQL View) |
Index Back |
---|---|
Run control recordRun control record |
SELECT A.GPBR_DRIVER_SEQ , A.OPRID , A.COMPANY , A.EMPLID , A.HIRE_DT , A.GPBR_EVENT_CD , A.GPBR_ES_SOURCE , A.GPBR_ES_STATUS_PH , A.USERID , A.ACTION_DATE , A.GPBR_PROTOC , A.GPBR_RECEIPT_NUM , E.DESCRLONG , A.GPBR_PRE_DRV_SEQ , A.GPBR_RECEIPT_PREV FROM %Table(GPBR_ES_PHIRE_D) A LEFT OUTER JOIN %Table(GPBR_ES_ERR_EVT) E ON A.GPBR_DRIVER_SEQ = E.GPBR_DRIVER_SEQ , %Table(GPBR_DRIVER_DAT) D WHERE A.GPBR_DRIVER_SEQ = D.GPBR_DRIVER_SEQ |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GPBR_DRIVER_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | Driver Sequence |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPBR_CMP_FLG_VW |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GPBR_ES_EMP_VW |
5 | HIRE_DT | Date(10) | DATE | First Start Date |
6 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
7 | GPBR_ES_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
Source process Batch
ILB=Initial Loading Basic Tables ILE=Initial Loading Employee MBT=Mapping Basic Tables MNP=Mapping Non Periodic PHR=Pre-Hiring Tables TER=Termination |
8 | GPBR_ES_STATUS_PH | Character(4) | VARCHAR2(4) NOT NULL |
Status Pre-Hiring
AEXC=Await Exclusion CANC=Canceled COMP=Complete ERRO=Error HIRE=Hired HPRO=Hiring in Progress PEHR=Pending Hiring RDY=Ready RECT=Rectified WHIR=Withdraw Hiring WPHR=Withdraw Pre-Hiring XSEN=Wait for Return |
9 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
10 | ACTION_DATE | Date(10) | DATE | Date of action |
11 | GPBR_PROTOC | Character(50) | VARCHAR2(50) NOT NULL | Protocol |
12 | GPBR_RECEIPT_NUM | Character(40) | VARCHAR2(40) NOT NULL | Receipt Num |
13 | DESCRLONG | Long Character | CLOB | Long Description |
14 | GPBR_PRE_DRV_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Pre Driver Sequence |
15 | GPBR_RECEIPT_PREV | Character(40) | VARCHAR2(40) NOT NULL | Register Previous |