ADM_T130_RAP_EC (SQL Table)	Index Back
TS130 Req, Att, and Prof Stg Admissions Application Electronic Commerce EDI Staging Table. Use ADM_TRNS_RAP_EC to store requirement, attribute and proficiency data for an applicant.

ADM_T130_RAP_EC

(SQL Table)

TS130 Req, Att, and Prof Stg

Admissions Application Electronic Commerce EDI Staging Table. Use ADM_TRNS_RAP_EC to store requirement, attribute and proficiency data for an applicant.

# 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 TRANS_CNTRL_NBR Character(9) VARCHAR2(9) NOT NULL Transaction Set Control Number

5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

6 TEST_REQ_CD Character(3) VARCHAR2(3) NOT NULL Test/Requirement Code

7 EDI_DESCR1 Character(80) VARCHAR2(80) NOT NULL Description 1

8 EDI_DESCR2 Character(80) VARCHAR2(80) NOT NULL Description 2

9 USAGE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Usage Indicator
A=Attribute
P=Proficiency
R=Requirement

10 COND_RESP_CODE Character(1) VARCHAR2(1) NOT NULL Condition or Response Code
Y/N Table Edit

11 STATUS_DT Date(10) DATE Status Date

12 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID

#	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	TRANS_CNTRL_NBR	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Control Number
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	TEST_REQ_CD	Character(3)	VARCHAR2(3) NOT NULL	Test/Requirement Code
7	EDI_DESCR1	Character(80)	VARCHAR2(80) NOT NULL	Description 1
8	EDI_DESCR2	Character(80)	VARCHAR2(80) NOT NULL	Description 2
9	USAGE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Usage Indicator A=Attribute P=Proficiency R=Requirement
10	COND_RESP_CODE	Character(1)	VARCHAR2(1) NOT NULL	Condition or Response Code Y/N Table Edit
11	STATUS_DT	Date(10)	DATE	Status Date
12	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID