AP_IPAC_FILE_VW

(SQL View)
Index Back

IPAC Filename View

View for FILENAME for inbound Search/select of IPAC stage data

SELECT FILENAME , ALC , IPAC_STAGE_DATE FROM PS_IPAC_HDR_STG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
2 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code
3 IPAC_STAGE_DATE Date(10) DATE Inbound IPAC Staged date for Hdr, detail, sgl