| # |
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_EFT_DTL_NBR |
Number(5,0) |
INTEGER NOT NULL |
Loan EFT Detail Record Number
|
| 5 |
CL_UNIQUE_ID4 |
Character(17) |
VARCHAR2(17) NOT NULL |
CL Loan Unique Identifier
|
| 6 |
CL_LOAD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
CommonLine Load Status
E=Error
S=Record Skipped
U=Unprocessed
Y=Processed
Default Value: U
|
| 7 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 8 |
CL_REC_TYPE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Type Indicator
|
| 9 |
CL_SEQ_NUM |
Character(2) |
VARCHAR2(2) NOT NULL |
Loan Sequence Nbr
|
| 10 |
CL_BORR_LNAME_O |
Character(35) |
VARCHAR2(35) NOT NULL |
Borrower Last Name
|
| 11 |
CL_BORR_FNAME_O |
Character(12) |
VARCHAR2(12) NOT NULL |
Borrower First Name
|
| 12 |
CL_BORR_MID_INIT_O |
Character(1) |
VARCHAR2(1) NOT NULL |
Borrower Middle Initial
|
| 13 |
CL_BORR_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Borrower SSN
|
| 14 |
CL_BORR_PERM_AD1_O |
Character(30) |
VARCHAR2(30) NOT NULL |
Borrower Permanent Addr Line 1
|
| 15 |
CL_BORR_PERM_AD2_O |
Character(30) |
VARCHAR2(30) NOT NULL |
Borrower Permanent Addr Line 2
|
| 16 |
CL_BORR_PERM_CITY3 |
Character(24) |
VARCHAR2(24) NOT NULL |
CommonLine Borrower Perm City
|
| 17 |
CL_BORR_PERM_ST2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Borrower Perm State
|
| 18 |
CL_BORR_PERM_ZIP_O |
Character(5) |
VARCHAR2(5) NOT NULL |
Borrower Permanent Zip
|
| 19 |
CL_BORR_PERM_ZP4_O |
Character(4) |
VARCHAR2(4) NOT NULL |
Borrower Permanent Zip Suffix
|
| 20 |
CL_PERM_ADDR_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Permanent Address Update Date
|
| 21 |
CL_EFT_AUTHRZTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Loan EFT Authorization
|
| 22 |
CL_STU_LNAME_O |
Character(35) |
VARCHAR2(35) NOT NULL |
P/A Student Last Name
|
| 23 |
CL_STU_FNAME_O |
Character(12) |
VARCHAR2(12) NOT NULL |
P/A Student First Name
|
| 24 |
CL_STU_MID_INIT_O |
Character(1) |
VARCHAR2(1) NOT NULL |
P/A Student Middle Initial
|
| 25 |
CL_STU_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Student SSN
|
| 26 |
CL_SCHOOL_ID3 |
Character(8) |
VARCHAR2(8) NOT NULL |
CommonLine School ID V3
|
| 27 |
CL_SCH_DES_BRCH_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
School Designated Branch Code
|
| 28 |
CL_SCHOOL_USE |
Character(23) |
VARCHAR2(23) NOT NULL |
CL School Use Field
|
| 29 |
CL_PERIOD_BEGIN_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Loan Period Begin Date
|
| 30 |
CL_PERIOD_END_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Loan Period End Date
|
| 31 |
CL_TYPE_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
CL Loan Type Code
|
| 32 |
CL_ALT_LN_TYPE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Alternative Loan Type Cd
|
| 33 |
CL_LNDR_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Lender ID
|
| 34 |
CL_LNDR_BRCH_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Lender Branch ID
|
| 35 |
CL_LNDR_USE |
Character(20) |
VARCHAR2(20) NOT NULL |
Lender Use Only
|
| 36 |
CL_BORR_CONFIRM_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
A code indicating if the service provider has received borrower confirmation of the MPN loan request.
N=No borr confirm received
Y=Yes, SP received borr confirm
|
| 37 |
CL_FUND_REL_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Funds Release Date
|
| 38 |
CL_DSBR_NBR |
Character(1) |
VARCHAR2(1) NOT NULL |
Disbursement Number
|
| 39 |
CL_TOT_DSBR_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Number of Disbursements
|
| 40 |
CL_GNTR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Guarantor ID
|
| 41 |
CL_GUAR_USE |
Character(23) |
VARCHAR2(23) NOT NULL |
Guarantor Use
|
| 42 |
CL_GUAR_DT |
Character(8) |
VARCHAR2(8) NOT NULL |
Guarantee Date
|
| 43 |
CL_GUAR_AMT |
Character(5) |
VARCHAR2(5) NOT NULL |
Guarantee Amount
|
| 44 |
CL_DSBR_GROSS_AMT |
Character(7) |
VARCHAR2(7) NOT NULL |
Gross Disbursement Amount
|
| 45 |
CL_ORIG_FEE |
Character(7) |
VARCHAR2(7) NOT NULL |
Origination Fee
|
| 46 |
CL_GUAR_FEE |
Character(7) |
VARCHAR2(7) NOT NULL |
Guarantee Fee
|
| 47 |
CL_DSBR_NET_AMT |
Character(7) |
VARCHAR2(7) NOT NULL |
Net Disbursement Amount
|
| 48 |
CL_FUND_DSBN_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Funds Distribution Method
|
| 49 |
CL_CHECK_NUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Check Number
|
| 50 |
CL_LATE_DSBR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Disbursement Indicator
|
| 51 |
CL_PREV_RPT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Previously Reported Indicator
|
| 52 |
CL_ERR_MSG_CD_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Message Code 1
|
| 53 |
CL_ERR_MSG_CD_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Message Code 2
|
| 54 |
CL_ERR_MSG_CD_3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Message Code 3
|
| 55 |
CL_ERR_MSG_CD_4 |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Message Code 4
|
| 56 |
CL_ERR_MSG_CD_5 |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Message Code 5
|
| 57 |
CL_FEES_PAID |
Character(7) |
VARCHAR2(7) NOT NULL |
Fees Paid
|
| 58 |
CL_LENDER_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Lender Name
|
| 59 |
CL_NET_CNCL_AMT |
Character(7) |
VARCHAR2(7) NOT NULL |
Net Cancellation Amount
|
| 60 |
CL_DUNS_SCHOOL_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS School ID
|
| 61 |
CL_DUNS_LENDER_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Lender ID
|
| 62 |
CL_DUNS_GUAR_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Guarantor ID
|
| 63 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 64 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 65 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
|
| 66 |
ITEM_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Item Type
|
| 67 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
|
| 68 |
DISBURSEMENT_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Disbursement ID
|
| 69 |
LN_APPL_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Loan Application Seq Num
|
| 70 |
SFA_CL_DIRECT_DISB |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Disb to Borrower
|
| 71 |
SFA_CL_GUAR_FEE_PD |
Character(5) |
VARCHAR2(5) NOT NULL |
Guarantee Fees Paid
|
| 72 |
SFA_CL_ORIG_FEE_PD |
Character(5) |
VARCHAR2(5) NOT NULL |
Origination Fees Paid
|
| 73 |
SFA_CL_ESIGN_TYPE |
Character(9) |
VARCHAR2(9) NOT NULL |
E-Signature Source Type Code
|