CAL_RUN_IDPAY_ENTITYGPCN_PSLP_PE_VW(SQL View) |
Index Back |
|---|---|
GP CHN - Payslip PayEntity VwGP China - SQL view for Pay Entity on GP Payment record |
| SELECT DISTINCT P.CAL_RUN_ID , E.PAY_ENTITY , E.DESCR FROM PS_GP_PYE_PRC_STAT P , PS_GP_PYE_SEG_STAT S , PS_GP_PYENT E WHERE P.EMPLID = S.EMPLID AND P.EMPL_RCD = S.EMPL_RCD AND P.GP_PAYGROUP = S.GP_PAYGROUP AND P.CAL_ID = S.CAL_ID AND P.CAL_RUN_ID = S.CAL_RUN_ID AND P.ORIG_CAL_RUN_ID = S.ORIG_CAL_RUN_ID AND S.PYE_CALC_STAT IN ('70', '75') AND P.PAY_ENTITY = E.PAY_ENTITY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |