AGENCY_CODE_VW(SQL View) |
Index Back |
|---|---|
Agency Location Code Table |
| SELECT CD.SETID ,CD.ALC ,CD.ALC_NON_DISBRSD ,CD.AGENCY_NAME ,CD.DESCRSHORT ,CD.ALC_BUS_ACTIVITY FROM PS_AGENCY_LOC_CD CD WHERE (CD.ALC_NON_DISBRSD = 'Y' OR CD.ALC IN ( SELECT CD2.ALC FROM PS_AGENCY_LOC_CD2 CD2 WHERE CD2.SETID = CD.SETID AND CD2.ALC = CD.ALC AND CD.ALC_BUS_ACTIVITY NOT IN ('00') AND CD2.GWA_REPORTER_CATG NOT IN ('00','01'))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ALC |
Character(8) | VARCHAR2(8) NOT NULL | Agency Location Code |
| 3 | ALC_NON_DISBRSD | Character(1) | VARCHAR2(1) NOT NULL |
PMC-21 requirement for JFMIP - allow override of ALC 8 digit numeric edit
Y/N Table Edit Default Value: N |
| 4 | AGENCY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Agency Name |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | ALC_BUS_ACTIVITY | Character(2) | VARCHAR2(2) NOT NULL |
ALC Business Activity type relates to the systems: IPAC, TDO Payments and CASHLINK II that can process an ALC's transactions. This field was added to support the Federal GWA modernization project.
00=No Business Activity Type 01=IPAC Only 02=AR Only 03=AP Payments Only 04=IPAC and AR 05=IPAC and AP Payments 06=AP Payments and AR 07=IPAC, AR and AP Pymts Default Value: 00 |