ISIR_00_TRAL_EC

(SQL Table)
Index Back

1999-2000 ISIR Trailer EC

Staging table for the 1999-2000 ISIR record.

# 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_RECORD_ID Character(12) VARCHAR2(12) NOT NULL ISIR Head/Trail Record Id
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 IWD_DEST_NBR Character(7) VARCHAR2(7) NOT NULL TG Number
7 IWD_CREATE_DATE Date(10) DATE File Create Date
8 IWD_CREATE_TIME Character(6) VARCHAR2(6) NOT NULL File Create Time
9 IWD_AWARD_YEAR Character(4) VARCHAR2(4) NOT NULL Award Year
10 IWD_TOTAL_REC_CNT Number(5,0) INTEGER NOT NULL Total Records
11 IWD_BATCH_NBR Character(23) VARCHAR2(23) NOT NULL Batch Number
12 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
13 IWD_TRANS_SITE_CD Character(1) VARCHAR2(1) NOT NULL Transaction Site Source Code
14 IWD_ACCEPT_REC_CNT Number(7,0) INTEGER NOT NULL Accepted Student Record Count
15 IWD_ERROR_REC_CNT Number(7,0) INTEGER NOT NULL Error Record Count
16 IWD_NOT_IN_DB_CNT Number(7,0) INTEGER NOT NULL Not in CPS DB Count
17 IWD_BATCH_IND Character(1) VARCHAR2(1) NOT NULL Batch Indicator
18 IWD_TRANS_SOURCE Character(2) VARCHAR2(2) NOT NULL Transaction Source Site Cd
19 IWD_INS_SEC_H_CNT Number(7,0) INTEGER NOT NULL INS Secondary Hold Count