OUAC_CTL_EC (SQL Table)	Index Back
Ouac Control Table OUAC Control Table used by post process.

OUAC_CTL_EC

(SQL Table)

Ouac Control Table

OUAC Control Table used by post process.

# 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 OUAC_TRAN_ID Character(2) VARCHAR2(2) NOT NULL OUAC Transaction Identifier

5 OUAC_REF_NBR Character(11) VARCHAR2(11) NOT NULL OUAC Reference Number

6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

7 OUAC_CNV_APPL_NBR Character(1) VARCHAR2(1) NOT NULL OUAC Converted Application Nbr

8 OUAC_DIST_NBR Character(2) VARCHAR2(2) NOT NULL OUAC Distribution Number

9 OUAC_APPL_NBR Character(2) VARCHAR2(2) NOT NULL OUAC Application Number

10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

11 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

12 DATE_LOADED Date(10) DATE Date Loaded

13 POSTED_DATE Date(10) DATE Date Posted

14 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

15 SRCH_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Search Match processing option
C=Complete
E=Error
P=Perform

16 MATCH_NBR Number(6,0) INTEGER NOT NULL Number of Matches

17 SEARCH_ORDER_NBR Number(3,0) SMALLINT NOT NULL This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.

#	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	OUAC_TRAN_ID	Character(2)	VARCHAR2(2) NOT NULL	OUAC Transaction Identifier
5	OUAC_REF_NBR	Character(11)	VARCHAR2(11) NOT NULL	OUAC Reference Number
6	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
7	OUAC_CNV_APPL_NBR	Character(1)	VARCHAR2(1) NOT NULL	OUAC Converted Application Nbr
8	OUAC_DIST_NBR	Character(2)	VARCHAR2(2) NOT NULL	OUAC Distribution Number
9	OUAC_APPL_NBR	Character(2)	VARCHAR2(2) NOT NULL	OUAC Application Number
10	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
11	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
12	DATE_LOADED	Date(10)	DATE	Date Loaded
13	POSTED_DATE	Date(10)	DATE	Date Posted
14	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
15	SRCH_PROC_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Search Match processing option C=Complete E=Error P=Perform
16	MATCH_NBR	Number(6,0)	INTEGER NOT NULL	Number of Matches
17	SEARCH_ORDER_NBR	Number(3,0)	SMALLINT NOT NULL	This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.