ECTRANSIDOUAC_REF_NBROUAC_APPL_NBROUAC_DIST_NBROUAC_TRAN_IDE=EDI Loaded
L=Loaded
P=Posted
R=Reviewed - Do Not Post
S=Suspense
OUAC_CTL_TRN_VW(SQL View) |
Index Back |
|---|---|
Ouac Control View w/ Tran ID |
| select distinct ectransid, ouac_ref_nbr, ouac_appl_nbr, ouac_dist_nbr, ouac_tran_id, date_loaded, ouac_prcs_status, institution from PS_OUAC_CTL_EC where ouac_tran_id <> 'B5' |
| # | 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 | OUAC_REF_NBR |
Character(11) | VARCHAR2(11) NOT NULL | OUAC Reference Number |
| 3 | OUAC_APPL_NBR |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Application Number |
| 4 | OUAC_DIST_NBR |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Distribution Number |
| 5 | OUAC_TRAN_ID |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Transaction Identifier |
| 6 | DATE_LOADED | Date(10) | DATE | Date Loaded |
| 7 | OUAC_PRCS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
OUAC Process Status
E=EDI Loaded L=Loaded P=Posted R=Reviewed - Do Not Post S=Suspense |
| 8 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |