OI_AGLOD_VW

(SQL View)
 Index Back

Agency Location Code

Primary record for Agency Location Code

SELECT AL.SETID , AL.ALC , AL.ALC_NON_DISBRSD , AL.AGENCY_NAME , AL.DESCRSHORT , XLI1.DESCR ALC_BUS_ACTIV_DESC , AL.PHONE , AL.IPAC_BULK_PREFIX , AL.IPAC_BULK_COUNTER FROM PS_AGENCY_LOC_CD AL LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = AL.ALC_BUS_ACTIVITY AND XLI1.CODESETGROUPNAME ='ALC_BUS_ACTIVITY' UNION SELECT SETID , ' ' , '-' , '-' , '-' , '-' , '-' , '-' , 0 FROM PS_SETID_TBL UNION SELECT ' ' , ' ' , '-' , '-' , '-' , '-' , '-' , '-' , 0 FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
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
4 AGENCY_NAME Character(30) VARCHAR2(30) NOT NULL Agency Name
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
6 ALC_BUS_ACTIV_DESC Character(30) VARCHAR2(30) NOT NULL Business Activity description
7 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
8 IPAC_BULK_PREFIX Character(3) VARCHAR2(3) NOT NULL IPAC Bulk Prefix
9 IPAC_BULK_COUNTER Number(5,0) INTEGER NOT NULL IPAC Bulk Counter