GPCH_EG_FSTA_VW

(SQL View)
 Index Back

ELM File Status View

ELM File Status View

SELECT DISTINCT P.GPCH_EG_TRANS_MODE %Concat CASE WHEN DT.GPCH_EG_VALIDATE ='Y' THEN P.GPCH_EG_VALIDATE ELSE 'N' END %Concat CASE WHEN DT.GPCH_EG_SIGN ='Y' THEN P.GPCH_EG_SIGN ELSE 'N' END %Concat CASE WHEN DT.GPCH_EG_ENCRYPT ='Y' THEN P.GPCH_EG_ENCRYPT ELSE 'N' END %Concat CASE WHEN DT.GPCH_EG_COMPRESS ='Y' THEN P.GPCH_EG_COMPRESS ELSE 'N' END %Concat CASE WHEN P.GPCH_EG_DISTRIBUTR ='Y' THEN P.GPCH_EG_DISTRIBUTR ELSE 'N' END ,D.COMPANY ,D.GPCH_EG_DOMAINID ,P.GPCH_SI_PROV_CD ,P.GPCH_SI_PROV_TYPE ,P.GPCH_EG_TRANS_MODE ,P.EFFDT ,P.GPCH_EG_DISTRIBUTR ,A.EFFDT FROM PS_GPCH_SI_COMPANY C , PS_GPCH_EG_DSET DT ,PS_GPCH_EG_DSETDTL D ,PS_GPCH_SI_PROVIDR P ,PS_GPCH_SI_ACC_INS A WHERE C.COMPANY =DT.COMPANY AND D.COMPANY =DT.COMPANY AND A.COMPANY =DT.COMPANY AND D.GPCH_EG_DOMAINID = DT.GPCH_EG_DOMAINID AND P.GPCH_SI_PROV_TYPE = D.GPCH_SI_PROV_TYPE AND A.GPCH_SI_PROV_TYPE = D.GPCH_SI_PROV_TYPE AND A.GPCH_TX_UV_PROV_CD = P.GPCH_SI_PROV_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPCH_EG_F_GROUB Character(10) VARCHAR2(10) NOT NULL File Group for EG
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets
4 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code
5 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
E=EO-APG
6 GPCH_EG_TRANS_MODE Character(3) VARCHAR2(3) NOT NULL ELM File TRansmission Mode(EIV/PIV)
1=EIV
2=PIV
7 EFFDT Date(10) DATE Effective Date

Default Value: %date

8 GPCH_EG_DISTRIBUTR Character(1) VARCHAR2(1) NOT NULL Flag to specify whether to use Distributor or Not
9 EFFDT_NEW Date(10) DATE New Effective Date