OUAC_CTL_SUS_VW

(SQL View)
Index Back

Ouac Control Table

OUAC Control Table used by post process.

select ECTRANSID, ECQUEUEINSTANCE, ECTRANSINOUTSW, OUAC_TRAN_ID, OUAC_REF_NBR, OUAC_CNV_APPL_NBR, OUAC_DIST_NBR, OUAC_APPL_NBR, SEQ_NUM, OUAC_PRCS_STATUS, DATE_LOADED, POSTED_DATE, EMPLID, SRCH_PROC_OPTN from PS_OUAC_CTL_EC where ouac_prcs_status = 'S'

# 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

Default Value: I

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 OUAC_CNV_APPL_NBR Character(1) VARCHAR2(1) NOT NULL OUAC Converted Application Nbr
7 OUAC_DIST_NBR Character(2) VARCHAR2(2) NOT NULL OUAC Distribution Number
8 OUAC_APPL_NBR Character(2) VARCHAR2(2) NOT NULL OUAC Application Number
9 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
10 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

Default Value: E

11 DATE_LOADED Date(10) DATE Date Loaded
12 POSTED_DATE Date(10) DATE Date Posted
13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
14 SRCH_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Search Match processing option
C=Complete
E=Error
P=Perform