GPBR_P_CALID_VW(SQL View) |
Index Back |
---|---|
Calendar Id |
SELECT DISTINCT B.GP_PAYGROUP ,B.CAL_ID ,A.DESCR FROM PS_GP_CAL_RUN A , PS_GP_CAL_RUN_DTL B , PS_GPBR_TER_COMP C WHERE A.RUN_FINALIZED_IND='N' AND A.CAL_RUN_ID=B.CAL_RUN_ID AND A.COUNTRY='BRA' AND b.cal_run_id=c.src_cal_run_id AND B.GP_PAYGROUP=C.GP_PAYGROUP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
2 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |