ADM_T189_REC_EC(SQL Table) |
Index Back |
|---|---|
Adm Applicant REC ECAdmissions Application Electronic Commerce EDI Staging Table. Recommender record for TS189 Applicant transactions. Use ADM_T189_REC_EC to store information about a person making a recommendation for a student. This table will hold the name, title, business, address and relationship to the application as well as the date of the recommendation, |
| # | 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 | RECOMM_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Recommendation Type
CNS=Counselor DNR=Dean's Report EMP=Employer FAC=Faculty TCH=Teacher |
| 7 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 8 | DESCR_EXT_ORG | Character(30) | VARCHAR2(30) NOT NULL | Org Name |
| 9 | DT_RECORDED | Date(10) | DATE | Date Recorded |
| 10 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 11 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 12 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 13 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 14 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 15 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 16 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 17 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 18 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 19 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 20 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 21 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 22 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 23 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 24 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 25 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 26 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 27 | RECOMM_TYPE_DESCR | Character(80) | VARCHAR2(80) NOT NULL | Recommendation Type |
| 28 | EDI_LNGTH_KNOWN_QL | Character(2) | VARCHAR2(2) NOT NULL |
Length Known Quant Qualifier
DY=Days MN=Month YY=Years |
| 29 | EDI_LENGTH_KNOWN | Number(15,0) | DECIMAL(15) NOT NULL | Length Known |
| 30 | EDI_REC_COM_QUAL1 | Character(2) | VARCHAR2(2) NOT NULL | Communication Qualifier 1 |
| 31 | EDI_REC_COM_NBR1 | Character(254) | VARCHAR2(254) NOT NULL | Communication Number 1 |
| 32 | EDI_REC_COM_QUAL2 | Character(2) | VARCHAR2(2) NOT NULL | Communication Qualifier 2 |
| 33 | EDI_REC_COM_NBR2 | Character(254) | VARCHAR2(254) NOT NULL | Communication Number 2 |
| 34 | EDI_REC_BUS_NAME | Character(60) | VARCHAR2(60) NOT NULL | Business Name |
| 35 | EDI_ID_CODE | Character(20) | VARCHAR2(20) NOT NULL | Identification Code |
| 36 | TRANS_ROW_ID | Character(3) | VARCHAR2(3) NOT NULL | Transaction Row ID |