GPBR_NOMOV_VW

(SQL View)
 Index Back

Periodic eSocial - Closing Per

eSocial Stage Table This record is used to generate information for eSocial layout S-1299 - Periodic - Closing Periodic Events TAG- evtFechaEvPer

SELECT B.COMPANY , B.GPBR_ESOC_YEAR , B.GPBR_ESOC_MONTHCD , C.GPBR_CAL_PRD_ID , B.GPBR_ES_PERIOD_TP , A.GPBR_EVENT_CD , B.GPBR_ES_PS , B.GPBR_PREV_YEAR , B.GPBR_PREV_MONTHCD , C.GPBR_COMP_MVT , A.GPBR_RECEIPT_NUM FROM %Table(GPBR_DRIVER_DAT) A , %Table(GPBR_DRVPER_XRF) B , %Table(GPBR_STG_CLOS) C WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND A.GPBR_STATUS = 'GSUC' AND A.GPBR_RECEIPT_NUM <> ' ' AND A.GPBR_PRE_DRV_SEQ = 0 AND A.GPBR_EVENT_CD = 'S-1299' AND A.GPBR_DRIVER_SEQ = C.GPBR_DRIVER_SEQ AND B.GPBR_PREV_YEAR <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
3 GPBR_ESOC_MONTHCD Character(2) VARCHAR2(2) NOT NULL eSocial Competency Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
4 GPBR_CAL_PRD_ID Character(7) VARCHAR2(7) NOT NULL eSocial Period Calculation
5 GPBR_ES_PERIOD_TP Character(1) VARCHAR2(1) NOT NULL eSocial Period Type
1=Monthly
2=Annual
6 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
7 GPBR_ES_PS Date(10) DATE eSocial on PeopleSoft Date
8 GPBR_PREV_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
9 GPBR_PREV_MONTHCD Character(2) VARCHAR2(2) NOT NULL eSocial Competency Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
10 GPBR_COMP_MVT Character(7) VARCHAR2(7) NOT NULL eSocial Period
11 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num