AGENCY_LOC_CD2(SQL Table) |
Index Back |
|---|---|
ALC GWA Reporter Categories |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: AGENCY_LOC_CD.SETID Prompt Table: SP_SETID_NONVW |
| 2 | ALC |
Character(8) | VARCHAR2(8) NOT NULL |
Agency Location Code
Default Value: AGENCY_LOC_CD.ALC |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | GWA_REPORTER_CATG | Character(2) | VARCHAR2(2) NOT NULL |
GWA Reporter Category identifies the transactions (IPAC, TDO Payments and CASHLINK) that are being reported with the GWA standard classification. This field was added to support the Federal GWA modernization project.
00=Non Reporter 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 |