GVT_SUBAGCY_VW (SQL View)	Index Back
GVT: Sub-Agency Table GVT: This is a prompt/validity table which is used to validate the bureau within an agency that a department is assigned to. Each Sub-agency will also have an entry in the department table so that the PeopleSoft Department Tree hierarchy will be left intact.

GVT_SUBAGCY_VW

(SQL View)

GVT: Sub-Agency Table

GVT: This is a prompt/validity table which is used to validate the bureau within an agency that a department is assigned to. Each Sub-agency will also have an entry in the department table so that the PeopleSoft Department Tree hierarchy will be left intact.

SELECT A.COMPANY , A.GVT_SUB_AGENCY , A.GVT_REPORT_CPDF FROM PS_GVT_SUBAGCY_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GVT_SUBAGCY_TBL B WHERE B.COMPANY= A.COMPANY AND B.GVT_SUB_AGENCY= A.GVT_SUB_AGENCY AND B.EFFDT <= %CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Default Value: INSTALLATION.COMPANY
Prompt Table: COMPANY_TBL

2 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

3 GVT_REPORT_CPDF Character(1) VARCHAR2(1) NOT NULL Report CPDF
Y/N Table Edit
Default Value: Y