ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
LN_DTL_NBRCL_APR_REF4_EC(SQL Table) |
Index Back |
|---|---|
CL 4 References EC RecEC Record Created 4/23/99 for CommonLine V4. |
| # | 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 | LN_DTL_NBR |
Number(5,0) | INTEGER NOT NULL | Loan Detail Line Number |
| 5 | CL_UNIQUE_ID4 | Character(17) | VARCHAR2(17) NOT NULL | CL Loan Unique Identifier |
| 6 | CL_REF_LAY_CD | Character(4) | VARCHAR2(4) NOT NULL | Reference Layout Owner Code |
| 7 | CL_REF_LAY_ID_CD | Character(2) | VARCHAR2(2) NOT NULL | Reference Layout ID Code |
| 8 | CL_REF1_LNAME | Character(35) | VARCHAR2(35) NOT NULL | Reference 1 Last Name |
| 9 | CL_REF1_FNAME | Character(12) | VARCHAR2(12) NOT NULL | Reference 1 First Name |
| 10 | CL_REF1_MI | Character(1) | VARCHAR2(1) NOT NULL | Reference 1 MI |
| 11 | CL_REF1_SSN | Character(9) | VARCHAR2(9) NOT NULL | Reference 1 SSN |
| 12 | CL_REF1_RELATION | Character(1) | VARCHAR2(1) NOT NULL | Reference 1 Relationship Code |
| 13 | CL_REF1_ADDR1 | Character(30) | VARCHAR2(30) NOT NULL | Reference 1 Address 1 |
| 14 | CL_REF1_ADDR2 | Character(30) | VARCHAR2(30) NOT NULL | Reference 1 Address 2 |
| 15 | CL_REF1_CITY | Character(24) | VARCHAR2(24) NOT NULL | Reference 1 City |
| 16 | CL_REF1_STATE | Character(2) | VARCHAR2(2) NOT NULL | Reference 1 State |
| 17 | CL_REF1_ZIP | Character(5) | VARCHAR2(5) NOT NULL | Reference 1 Zip |
| 18 | CL_REF1_ZIP_SFX | Character(4) | VARCHAR2(4) NOT NULL | Reference 1 Zip Suffix |
| 19 | CL_REF1_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Reference 1 Phone |
| 20 | CL_REF2_LNAME | Character(35) | VARCHAR2(35) NOT NULL | Reference 2 Last Name |
| 21 | CL_REF2_FNAME | Character(12) | VARCHAR2(12) NOT NULL | Reference 2 First Name |
| 22 | CL_REF2_MI | Character(1) | VARCHAR2(1) NOT NULL | Reference 2 MI |
| 23 | CL_REF2_SSN | Character(9) | VARCHAR2(9) NOT NULL | Reference 2 SSN |
| 24 | CL_REF2_RELATION | Character(1) | VARCHAR2(1) NOT NULL | Reference 2 Relationship Code |
| 25 | CL_REF2_ADDR1 | Character(30) | VARCHAR2(30) NOT NULL | Reference 2 Address 1 |
| 26 | CL_REF2_ADDR2 | Character(30) | VARCHAR2(30) NOT NULL | Reference 2 Address 2 |
| 27 | CL_REF2_CITY | Character(24) | VARCHAR2(24) NOT NULL | Reference 2 CIty |
| 28 | CL_REF2_STATE | Character(2) | VARCHAR2(2) NOT NULL | Reference 2 State |
| 29 | CL_REF2_ZIP | Character(5) | VARCHAR2(5) NOT NULL | Reference 2 Zip |
| 30 | CL_REF2_ZIP_SFX | Character(4) | VARCHAR2(4) NOT NULL | Reference 2 Zip Suffix |
| 31 | CL_REF2_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Reference 2 Phone |
| 32 | CL_BORR_EMPLOYER | Character(20) | VARCHAR2(20) NOT NULL | Borrower Employer Name |
| 33 | CL_BORR_EMPL_ADDR1 | Character(30) | VARCHAR2(30) NOT NULL | Borrower Employer Addr 1 |
| 34 | CL_BORR_EMPL_ADDR2 | Character(30) | VARCHAR2(30) NOT NULL | Borrower Employer Addr 2 |
| 35 | CL_BORR_EMPL_CITY | Character(24) | VARCHAR2(24) NOT NULL | Borrower Employer City |
| 36 | CL_BORR_EMPL_STATE | Character(2) | VARCHAR2(2) NOT NULL | Borrower Employer State |
| 37 | CL_BORR_EMPL_ZIP | Character(5) | VARCHAR2(5) NOT NULL | Borrower Employer Zip |
| 38 | CL_BORR_EMPL_ZIP4 | Character(4) | VARCHAR2(4) NOT NULL | Borrower Employer Zip4 |
| 39 | CL_BORR_EMPL_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Borrower Employer Phone |
| 40 | CL_FOREIGN_POST_R1 | Character(14) | VARCHAR2(14) NOT NULL | Foreign Postal Code Ref 1 |
| 41 | CL_FOREIGN_POST_R2 | Character(14) | VARCHAR2(14) NOT NULL | Foreign Postal Code Ref 2 |
| 42 | CL_BOCO_CREDIT_IND | Character(1) | VARCHAR2(1) NOT NULL | Borr/Cosigner Credit Indicator |
| 43 | CL_BOCO_HOUSE_PAY | Character(5) | VARCHAR2(5) NOT NULL | Borrower/Cosigner Housing Paym |
| 44 | CL_BOCO_OWN_RENT | Character(1) | VARCHAR2(1) NOT NULL | Borrower/Cosigner Own/Rent Ind |
| 45 | CL_BOCO_PRE_ADDR1 | Character(30) | VARCHAR2(30) NOT NULL | Previous Address 1 |
| 46 | CL_BOCO_PRE_ADDR2 | Character(30) | VARCHAR2(30) NOT NULL | Previous Address 2 |
| 47 | CL_BOCO_PRE_CITY | Character(24) | VARCHAR2(24) NOT NULL | Borrower/CosignerPrevious City |
| 48 | CL_BOCO_PRE_STATE | Character(2) | VARCHAR2(2) NOT NULL | Borrower/Cosigner Prev State |
| 49 | CL_BOCO_PRE_ZIP | Character(5) | VARCHAR2(5) NOT NULL | Borrower/Cosigner Previous Zip |
| 50 | CL_BOCO_PRE_ZIP4 | Character(4) | VARCHAR2(4) NOT NULL | Borrower/Cosigner Prev Zip+4 |
| 51 | CL_BOCO_SELF_EMPL | Character(1) | VARCHAR2(1) NOT NULL | Borrower/Cosigner Self Employ |
| 52 | CL_BOCO_COMPANY | Character(30) | VARCHAR2(30) NOT NULL | Borrower/Cosigner Company |
| 53 | CL_BOCO_JOB_POSIT | Character(26) | VARCHAR2(26) NOT NULL | Borrower/Cosigner Job Position |
| 54 | CL_BOCO_YRS_AT_JOB | Character(2) | VARCHAR2(2) NOT NULL | Borrower/Cosigner Yrs at Job |
| 55 | CL_BOCO_PRE_EMPLOY | Character(30) | VARCHAR2(30) NOT NULL | Borrower/Cosign Prev Employer |
| 56 | CL_BOCO_PREV_JOB | Character(30) | VARCHAR2(30) NOT NULL | Borrower/Cosigner Prev Job |
| 57 | CL_BOCO_PJOB_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Borrower/Cosign Prev Job Phone |
| 58 | CL_BOCO_OT_INC_SRC | Character(15) | VARCHAR2(15) NOT NULL | Borr/Cosig Othr Income Source |