ISIR_LD11_SRCH

(SQL View)
 Index Back

2010-2011 ISIR Load Search

Search record for viewing loaded ISIR batches

SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.IWD_DEST_NBR , A.IWD_BATCH_NBR , A.ISIR_LOAD_DTTM , B.IWD_TOTAL_REC_CNT , B.IWD_TRANS_SRC_CD FROM PS_ISIR_00_HEAD_EC A , PS_ISIR_00_TRAL_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.ECTRANSID = 'CPS_ISIR_2011'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound

Default Value: I

4 IWD_DEST_NBR Character(7) VARCHAR2(7) NOT NULL TG Number
5 IWD_BATCH_NBR Character(23) VARCHAR2(23) NOT NULL Batch Number
6 ISIR_LOAD_DTTM DateTime(26) TIMESTAMP ISIR Load Date:Time
7 IWD_TOTAL_REC_CNT Number(5,0) INTEGER NOT NULL Total Records
8 IWD_TRANS_SRC_CD Character(1) VARCHAR2(1) NOT NULL Transaction Source Code
1=Electroni Initial App
2=Electronic Renewal App
3=Electronic History Correction
4=FAFSA Express
5=ACT
6=Web FAFSA/Renewal FAFSA
7=NCS
8=PIC