ISIR_09_OUT_VW

(SQL View)
Index Back

2008-2009 ISIR Output Rep View

View for reporting info on outgoing CPS records starting with the 2008-2009 year.

SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.IWD_BATCH_NBR , A.IWD_RECORD_TYPE , A.INSTITUTION , A.AID_YEAR , A.IWD_CREATE_DATE , A.IWD_CREATE_TIME , A.IWD_AWARD_YEAR , A.ISIR_LOAD_DTTM , B.IWD_TOTAL_REC_CNT , B.IWD_ACCEPT_REC_CNT , B.IWD_ERROR_REC_CNT , B.IWD_NOT_IN_DB_CNT FROM PS_ISIR_EX_HEAD_EC A , PS_ISIR_EX_TRAL_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.ECTRANSID IN ('EAPS09IN', 'CORR09IN', 'SIGS09IN')

# 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
4 IWD_BATCH_NBR Character(23) VARCHAR2(23) NOT NULL Batch Number
5 IWD_RECORD_TYPE Character(1) VARCHAR2(1) NOT NULL Record Type
7=PIN Request
A=Initial Applications
C=Corrections/Duplicates
F=FDR Request
H=Corrections/Duplicate Req
R=Renewal Applications
S=Signature Corrections
6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
7 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
8 IWD_CREATE_DATE Date(10) DATE File Create Date
9 IWD_CREATE_TIME Character(6) VARCHAR2(6) NOT NULL File Create Time
10 IWD_AWARD_YEAR Character(4) VARCHAR2(4) NOT NULL Award Year
11 ISIR_LOAD_DTTM DateTime(26) TIMESTAMP ISIR Load Date:Time
12 IWD_TOTAL_REC_CNT Number(5,0) INTEGER NOT NULL Total Records
13 IWD_ACCEPT_REC_CNT Number(7,0) INTEGER NOT NULL Accepted Student Record Count
14 IWD_ERROR_REC_CNT Number(7,0) INTEGER NOT NULL Error Record Count
15 IWD_NOT_IN_DB_CNT Number(7,0) INTEGER NOT NULL Not in CPS DB Count