GPBR_ES_PH_D_VW(SQL View) |
Index Back |
|---|---|
Monitor view pre-hiringMonitor view pre-hiring |
| SELECT PHR.EMPLID , PHR.COMPANY , PHR.GPBR_EVENT_CD , PHR.HIRE_DT , PHR.GPBR_ES_STATUS_PH , PHR.ACTION_DATE , PHR.REG_REGION , PHR.SETID_EMPL_CLASS , PHR.EMPL_CLASS , PHR.BUSINESS_UNIT , PHR.SETID_JOBCODE , PHR.JOBCODE , PHR.CBO_CD_BRA , PHR.COMPRATE , PHR.CONT_SAL_TYPE_BRA , PHR.CNTR_TYPE_BRA , PHR.CONTRACT_END_DT , PHR.REG_ESOCIAL_BRA , XRF.GPBR_RECT FROM %Table(GPBR_ES_PHIRE_D) PHR , %Table(GPBR_DRIVER_DAT) DAT , %Table(GPBR_DRVEMP_XRF) XRF WHERE PHR.GPBR_DRIVER_SEQ = DAT.GPBR_DRIVER_SEQ AND DAT.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND PHR.GPBR_ES_STATUS_PH NOT IN ('AEXC', 'HPRO', 'WPHR', 'HIRE') AND NOT EXISTS ( SELECT 'X' FROM %Table(GPBR_ES_PHIRE_D) PHR1 WHERE PHR1.GPBR_DRIVER_SEQ = PHR.GPBR_DRIVER_SEQ AND PHR1.GPBR_EVENT_CD IN ('S-2200', 'S-3000') AND PHR1.GPBR_ES_STATUS_PH = 'CANC') AND PHR.GPBR_DRIVER_SEQ = ( SELECT MAX(PHR2.GPBR_DRIVER_SEQ) FROM %Table(GPBR_ES_PHIRE_D) PHR2 WHERE PHR.EMPLID = PHR2.EMPLID AND PHR.COMPANY = PHR2.COMPANY) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GPBR_ES_EMP_VW |
| 2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPBR_CMP_FLG_VW |
| 3 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 4 | HIRE_DT | Date(10) | DATE | First Start Date |
| 5 | 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 |
| 6 | ACTION_DATE | Date(10) | DATE | Date of action |
| 7 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 8 | SETID_EMPL_CLASS | Character(5) | VARCHAR2(5) NOT NULL | Employee class Set ID |
| 9 | EMPL_CLASS | Character(3) | VARCHAR2(3) NOT NULL | Employee Classification |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 12 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 13 | CBO_CD_BRA | Character(7) | VARCHAR2(7) NOT NULL | Occupation Code for Brazil |
| 14 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 15 | CONT_SAL_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly 2=Fortnightly 3=Weekly 4=Daily 5=Hourly 6=Per Task 7=Commission 8=Other |
| 16 | CNTR_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Contract Type Bra
1=Indeterminate 2=Indeterminate w/probation prd 3=Determinate |
| 17 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |
| 18 | REG_ESOCIAL_BRA | Character(30) | VARCHAR2(30) NOT NULL | eSocial Reg. Number |
| 19 | GPBR_ES_DRV_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of eSocial Driver event.
0=Original 1=Original 2=Rectifier 9=Rectified |