GPGB_PYE_VW(SQL View) |
Index Back |
---|---|
View on Calendar DetailGP UK - Calendar Detail view |
SELECT A.CAL_RUN_ID , A.PAY_ENTITY FROM PS_GP_CAL_RUN_DTL A WHERE A.CALC_TYPE='P' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_RUN_DTL |
2 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_CAL_RUN_DTL |