AGENCY_LOC_VW

(SQL View)
Index Back

Agency Location Code Table


SELECT ALC ,ALC_NON_DISBRSD ,AGENCY_NAME FROM PS_AGENCY_LOC_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code
2 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

3 AGENCY_NAME Character(30) VARCHAR2(30) NOT NULL Agency Name