ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
CL_DTL_SEQ_NUMCL_APX_ALT4_EC(SQL Table) |
Index Back |
|---|---|
CL 4 ALt Loan Export 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 | CL_DTL_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Loan Sequence Number |
| 5 | CL_UNIQUE_ID4 | Character(17) | VARCHAR2(17) NOT NULL | CL Loan Unique Identifier |
| 6 | CL_TYPE_CODE | Character(2) | VARCHAR2(2) NOT NULL | CL Loan Type Code |
| 7 | CL_ALT_LAY_OWN_CD | Character(4) | VARCHAR2(4) NOT NULL | Alt Loan Owner Layout Code |
| 8 | CL_ALT_LAY_ID_CD | Character(2) | VARCHAR2(2) NOT NULL | Alt Loan Layout ID Code |
| 9 | CL_STAF_DEBT_AMT | Character(5) | VARCHAR2(5) NOT NULL | Federal Stafford Loan Debt |
| 10 | CL_SLS_DEBT_AMT | Character(5) | VARCHAR2(5) NOT NULL | Federal SLS Debt |
| 11 | CL_HEAL_DEBT_AMT | Character(6) | VARCHAR2(6) NOT NULL | Heal Loan Debt |
| 12 | CL_PERK_DEBT_AMT | Character(5) | VARCHAR2(5) NOT NULL | Perkins Loan Debt |
| 13 | CL_OTHER_DEBT_AMT | Character(6) | VARCHAR2(6) NOT NULL | Other Loan Debt |
| 14 | CL_OTHR_LN_IN_PER | Character(7) | VARCHAR2(7) NOT NULL | Other Loans in This Period |
| 15 | CL_DIFF_NAME_CD | Character(1) | VARCHAR2(1) NOT NULL | Credit Under Different Name Cd |
| 16 | CL_COS1_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Cosigner 1 Last Name |
| 17 | CL_COS1_FIRST_NAME | Character(12) | VARCHAR2(12) NOT NULL | Cosigner 1 First Name |
| 18 | CL_COS1_MID_INIT | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 1 Middle Initial |
| 19 | CL_COS1_SSN | Character(9) | VARCHAR2(9) NOT NULL | Cosigner 1 SSN |
| 20 | CL_COS1_CIT_CD | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 1 U.S. Citizenship Cd |
| 21 | CL_COS1_ADDR1 | Character(30) | VARCHAR2(30) NOT NULL | Cosigner 1 Address Line 1 |
| 22 | CL_COS1_ADDR2 | Character(30) | VARCHAR2(30) NOT NULL | Cosigner 1 Address Line 2 |
| 23 | CL_COS1_CITY3 | Character(24) | VARCHAR2(24) NOT NULL | CommonLine Cosigner 1 Perm Cty |
| 24 | CL_COS1_STATE_CD2 | Character(2) | VARCHAR2(2) NOT NULL | Cosigner 1 State Code |
| 25 | CL_COS1_ZIP_O | Character(5) | VARCHAR2(5) NOT NULL | Cosigner 1 Zip |
| 26 | CL_COS1_ZIP_SFX | Character(4) | VARCHAR2(4) NOT NULL | Cosigner 1 Zip Code Suffix |
| 27 | CL_COS1_PHONE10 | Character(10) | VARCHAR2(10) NOT NULL | Cosigner 1 Phone10 |
| 28 | CL_COS1_SIG_CD | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 1 Signature Code |
| 29 | CL_COS2_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Cosigner 2 Last Name |
| 30 | CL_COS2_FIRST_NAME | Character(12) | VARCHAR2(12) NOT NULL | Cosigner 2 First Name |
| 31 | CL_COS2_MID_INIT | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 2 Middle Initial |
| 32 | CL_COS2_SSN | Character(9) | VARCHAR2(9) NOT NULL | Cosigner 2 SSN |
| 33 | CL_COS2_CIT_CD | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 2 U.S. Citizenship Cd |
| 34 | CL_COS2_ADDR1 | Character(30) | VARCHAR2(30) NOT NULL | Cosigner 2 Address Line 1 |
| 35 | CL_COS2_ADDR2 | Character(30) | VARCHAR2(30) NOT NULL | Cosigner 2 Address Line 2 |
| 36 | CL_COS2_CITY3 | Character(24) | VARCHAR2(24) NOT NULL | CommonLine Cosigner 2 Perm Cty |
| 37 | CL_COS2_STATE_CD2 | Character(2) | VARCHAR2(2) NOT NULL | Cosigner 2 State Code |
| 38 | CL_COS2_ZIP_O | Character(5) | VARCHAR2(5) NOT NULL | Cosigner 2 Zip Code |
| 39 | CL_COS2_ZIP_SFX | Character(4) | VARCHAR2(4) NOT NULL | Cosigner 2 Zip Code Suffix |
| 40 | CL_COS2_PHONE10 | Character(10) | VARCHAR2(10) NOT NULL | Cosigner 2 Phone10 |
| 41 | CL_COS2_SIG_CD | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 2 Signature Code |
| 42 | CL_BORR_SALARY | Character(7) | VARCHAR2(7) NOT NULL | Borrower Gross Annual Salary |
| 43 | CL_BORR_OTH_INC | Character(7) | VARCHAR2(7) NOT NULL | Borrower Other Income |
| 44 | CL_COS1_SALARY | Character(7) | VARCHAR2(7) NOT NULL | Cosigner 1 Gross Annual Salary |
| 45 | CL_COS1_OTH_INC | Character(7) | VARCHAR2(7) NOT NULL | Cosigner 1 Other Income |
| 46 | CL_COS2_SALARY | Character(7) | VARCHAR2(7) NOT NULL | Cosigner 2 Gross Annual Salary |
| 47 | CL_COS2_OTH_INC | Character(7) | VARCHAR2(7) NOT NULL | Cosigner 2 Other Income |
| 48 | CL_FOREIGN_POST_C1 | Character(14) | VARCHAR2(14) NOT NULL | Foreign Postal Code Cos 1 |
| 49 | CL_FOREIGN_POST_C2 | Character(14) | VARCHAR2(14) NOT NULL | Foreign Postal Code Cos 2 |
| 50 | CL_STUDENT_MAJOR | Character(15) | VARCHAR2(15) NOT NULL | Student's Major |
| 51 | CL_COS1_BIRTHDT | Character(8) | VARCHAR2(8) NOT NULL | Cosigner 1 Birthdate |
| 52 | CL_COS1_DL_STATE | Character(2) | VARCHAR2(2) NOT NULL | Cos 1 Drivers Lic State |
| 53 | CL_COS1_DL_NUM | Character(20) | VARCHAR2(20) NOT NULL | Cosigner 1 Drivers Lic Number |
| 54 | CL_COS2_BIRTHDT | Character(8) | VARCHAR2(8) NOT NULL | Cosigner 2 Birthdate |
| 55 | CL_COS2_DL_STATE | Character(2) | VARCHAR2(2) NOT NULL | Cos 2 Drivers Lic State |
| 56 | CL_COS2_DL_NUM | Character(20) | VARCHAR2(20) NOT NULL | Cosigner 2 Drivers Lic Number |
| 57 | CL_STU_SCHL_PHONE | Character(10) | VARCHAR2(10) NOT NULL | Student's School Phone |
| 58 | CL_COS1_RELATE_STU | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 1 Relationship to Stu |
| 59 | CL_COS1_SUFFIX | Character(3) | VARCHAR2(3) NOT NULL | Cosigner 1 suffix |
| 60 | CL_COS1_YRS_ADDR | Character(2) | VARCHAR2(2) NOT NULL | Cosigner 1 Years at Address |
| 61 | CL_COS2_RELATE_STU | Character(1) | VARCHAR2(1) NOT NULL | Cosigner 2 Relationship to Stu |
| 62 | CL_COS2_SUFFIX | Character(3) | VARCHAR2(3) NOT NULL | Cosigner 1 suffix |
| 63 | CL_COS2_YRS_ADDR | Character(2) | VARCHAR2(2) NOT NULL | Cosigner 2 Years at Address |
| 64 | CL_INT_RATE_OPT | Character(1) | VARCHAR2(1) NOT NULL | Interest Rate Option |
| 65 | CL_REPAY_OPT_CD | Character(1) | VARCHAR2(1) NOT NULL | Repayment Option Code |