ALC_ADDSRCH_VW

(SQL View)
Index Back

ALC Addsrch view

Addsearch view for ALC codes

SELECT SETID , ALC , ALC_NON_DISBRSD FROM PS_AGENCY_LOC_CD

# 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