ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
7=PIN Request
A=Initial Applications
C=Corrections/Duplicates
F=FDR Request
H=Corrections/Duplicate Req
R=Renewal Applications
S=Signature Corrections
ISIR_18_OUT_VW(SQL View) |
Index Back |
|---|---|
2017-2018 ISIR Output Rep ViewView for reporting info on outgoing CPS records starting with the 2017-2018 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 ('EAPS18IN', 'CORR18IN', 'SIGS18IN') |
| # | 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 |