ADM_T189_COM_EC (SQL Table)	Index Back
Adm Applicant Com EC Admissions Application Electronic Commerce EDI Staging Table. Communication record for TS189 Applicant transactions. Use ADM_T189_COM_EC to store communication data about an employee or applicant.

ADM_T189_COM_EC

(SQL Table)

Adm Applicant Com EC

Admissions Application Electronic Commerce EDI Staging Table. Communication record for TS189 Applicant transactions. Use ADM_T189_COM_EC to store communication data about an employee or applicant.

Parent record: ADM_T189_PER_EC

# 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 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr

6 EDI_COM_TYPE Character(4) VARCHAR2(4) NOT NULL EDI Communication Type
01=EMail - University Provided
02=EMail - Work
03=EMail - Home
BUSN=Business
CAMP=Campus
CELL=Cellular
DORM=Dormitory
FAX=FAX
HOME=Home
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex

7 EDI_COM_NBR Character(80) VARCHAR2(80) NOT NULL Communication Number

8 EDI_DATE1_QUAL Character(3) VARCHAR2(3) NOT NULL EDI Date 1 Qualifier
007=Effective Date
036=Expiration Date
043=Publication Date
050=Received Date
055=Confirmed Date
102=Issue Date
103=Award Date
196=Start Date
197=End Date
198=Completion Date
222=Birth Date
237=Student Signed
270=Date Filed
275=Approved Date
330=Referral Date
331=Evaluation Date
332=Placement Date
333=Individual Education Plan
334=Re-evaluation Date
335=Dismissal Date
336=Employment Begin Date
337=Employment End Date
442=Date of Death
467=Signature Date
574=Action Begin Date
576=Action End Date

9 EDI_DATE1 Date(10) DATE Date 1

10 EDI_DATE2_QUAL Character(3) VARCHAR2(3) NOT NULL EDI Date 2 Qualifier
007=Effective Date
036=Expiration Date

11 EDI_DATE2 Date(10) DATE Date 2

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	RELATIONSHIP_NBR	Number(2,0)	SMALLINT NOT NULL	Relationship Nbr
6	EDI_COM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	EDI Communication Type 01=EMail - University Provided 02=EMail - Work 03=EMail - Home BUSN=Business CAMP=Campus CELL=Cellular DORM=Dormitory FAX=FAX HOME=Home OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex
7	EDI_COM_NBR	Character(80)	VARCHAR2(80) NOT NULL	Communication Number
8	EDI_DATE1_QUAL	Character(3)	VARCHAR2(3) NOT NULL	EDI Date 1 Qualifier 007=Effective Date 036=Expiration Date 043=Publication Date 050=Received Date 055=Confirmed Date 102=Issue Date 103=Award Date 196=Start Date 197=End Date 198=Completion Date 222=Birth Date 237=Student Signed 270=Date Filed 275=Approved Date 330=Referral Date 331=Evaluation Date 332=Placement Date 333=Individual Education Plan 334=Re-evaluation Date 335=Dismissal Date 336=Employment Begin Date 337=Employment End Date 442=Date of Death 467=Signature Date 574=Action Begin Date 576=Action End Date
9	EDI_DATE1	Date(10)	DATE	Date 1
10	EDI_DATE2_QUAL	Character(3)	VARCHAR2(3) NOT NULL	EDI Date 2 Qualifier 007=Effective Date 036=Expiration Date
11	EDI_DATE2	Date(10)	DATE	Date 2
12	TRANS_ROW_ID	Character(3)	VARCHAR2(3) NOT NULL	Transaction Row ID