GPCH_SI_SPL1_VW

(SQL View)
 Index Back

View to prompt valid entries

View to prompt valid entries for EE's ,Company and Grade

SELECT J.EMPLID , S.COMPANY , S.GPCH_SI_TYPE_ID ,S.GPCH_SI_ALT_ID ,T2.XLATLONGNAME ,S.GPCH_SI_PROV_TYPE FROM PS_GPCH_SI_SPLIT S , PS_JOB J , PSXLATITEM T , PSXLATITEM T1 ,PSXLATITEM T2 WHERE J.COMPANY = S.COMPANY AND J.GRADE = S.GRADE AND S.EFFDT = ( SELECT MAX(A.EFFDT) FROM PS_GPCH_SI_ADDTNL1 A WHERE S.COMPANY = A.COMPANY AND S.GPCH_SI_PROV_TYPE = A.GPCH_SI_PROV_TYPE AND A.EFF_STATUS = 'A' AND A.EFFDT <= J.EFFDT ) AND T.FIELDNAME = 'GPCH_SI_PROV_TYPE' AND T.FIELDVALUE = S.GPCH_SI_PROV_TYPE AND T1.FIELDNAME = 'GPCH_SI_TYPE_ID' AND T1.FIELDVALUE = S.GPCH_SI_TYPE_ID AND T2.FIELDNAME = 'GPCH_SI_ALT_ID' AND T2.FIELDVALUE = S.GPCH_SI_ALT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 GPCH_SI_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Insurance Type ID
4 GPCH_SI_ALT_ID Character(8) VARCHAR2(8) NOT NULL Insurance Alternative ID
5 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
6 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
0=Identify
1=Others
2=UVG-LAA
3=KTG-AMC
4=UVGZ-LAAC
5=FAK-CAF
6=BVG-LPP
7=AHV-AVS
8=LAW-CDS
9=BFS-OFS
A=QST-IS
B=Write File
C=Base AL08
D=GRFI-FRFI
E=EO-APG
I=BNK_BNQ