GPBR_ABS_CID_VW

(SQL View)
 Index Back

View To retrive CID label

View To retrive field number that contains CID label

SELECT A.COUNTRY , A.PIN_TAKE_NUM , C.PIN_NUM , A.EFFDT , A.EFF_STATUS , D.FIELDNAME FROM (PS_GP_ABS_SS A LEFT OUTER JOIN PS_GP_ABS_SS_LANG B ON A.COUNTRY = B.COUNTRY AND A.PIN_TAKE_NUM = B.PIN_TAKE_NUM AND B.EFFDT = A.EFFDT ) , PS_GP_PIN C , PSRECFIELD D WHERE ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GP_ABS_SS A_ED WHERE A.COUNTRY = A_ED.COUNTRY AND A.PIN_TAKE_NUM = A_ED.PIN_TAKE_NUM AND A_ED.EFFDT <= %CurrentDateIn) AND A.COUNTRY = 'BRA' AND D.RECNAME = 'GP_ABS_SS' AND ( (( A.ABS_USER_FLD1_LBL LIKE '%CID%' OR B.ABS_USER_FLD1_LBL LIKE '%CID%') AND C.PIN_NM = 'EVT CONFIG1 CH' AND D.FIELDNAME = 'ABS_USER_FLD1_LBL') OR (( A.ABS_USER_FLD2_LBL LIKE '%CID%' OR B.ABS_USER_FLD2_LBL LIKE '%CID%') AND C.PIN_NM = 'EVT CONFIG2 CH' AND D.FIELDNAME = 'ABS_USER_FLD2_LBL') OR (( A.ABS_USER_FLD3_LBL LIKE '%CID%' OR B.ABS_USER_FLD3_LBL LIKE '%CID%') AND C.PIN_NM = 'EVT CONFIG3 CH' AND D.FIELDNAME = 'ABS_USER_FLD3_LBL') OR (( A.ABS_USER_FLD4_LBL LIKE '%CID%' OR B.ABS_USER_FLD4_LBL LIKE '%CID%') AND C.PIN_NM = 'EVT CONFIG4 CH' AND D.FIELDNAME = 'ABS_USER_FLD4_LBL') ) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_CNTRY_OP_VW

2 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).