GPCH_AL_CPAY_ENDDTDefault Value: GPCH_RC_PAYROLL.GPCH_AL_CPAY_ENDDT
Prompt Table: GPCH_RP_YEAR_VW
GPCH_RP_DATE_VW(SQL View) |
Index Back |
|---|---|
Current Pay End Date Prompt VWCurrent Pay End Date Prompt VW |
| SELECT DISTINCT CI.PRD_END_DT ,TO_CHAR (CI.PRD_END_DT , 'YYYY') FROM PS_GP_CAL_RUN CPS ,PS_GP_CAL_RUN_DTL CI WHERE CPS.CAL_RUN_ID = CI.CAL_RUN_ID AND CI.CALC_TYPE = 'P' AND (CPS.RUN_FINALIZED_IND = 'Y' OR CPS.RUN_OPEN_IND = 'Y') AND CI.COUNTRY = 'CHE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_AL_CPAY_ENDDT |
Date(10) | DATE | Current Pay End Date |
| 2 | YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Character field to represent a year
Default Value: GPCH_RC_PAYROLL.GPCH_AL_CPAY_ENDDT Prompt Table: GPCH_RP_YEAR_VW |