GPBR_ES_HIRE_VW

(SQL View)
Index Back

Run control record

Run 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