ISIR_00_4A_EC(SQL Table) |
Index Back |
|---|---|
1999-2000 ISIR section 4 ECStaging table section 4 of the 1999-2000 ISIR. Fields 329 - 520. |
| # | 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 | ISIR_SEQ_NO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | ORIG_SSN | Character(9) | VARCHAR2(9) NOT NULL | Original SSN |
| 6 | NAME_CD | Character(2) | VARCHAR2(2) NOT NULL | Name Code |
| 7 | NSLDS_TXN_NBR | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Transaction Nbr |
| 8 | NSLDS_LOAN_SEQCH1 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Sequence Num |
| 9 | NSLDS_LN_TYPE_CD1 | Character(1) | VARCHAR2(1) NOT NULL |
NSLDS Loan Type Code
D=Defaulted F=Fraud R=Recent T=Discharged |
| 10 | NSLDS_CHANGE_FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Change Flag |
| 11 | NSLDS_LOAN_PGMCD1 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Program Code |
| 12 | NSLDS_NET_LN_AMT1 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Net Loan Amt |
| 13 | NSLDS_STATUS_CD1 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Current Status Code |
| 14 | NSLDS_STAT_DT_1 | Date(10) | DATE | Loan Status Effective Date |
| 15 | NSLDS_PRIN_BAL_CH1 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Loan OPB |
| 16 | NSLDS_BAL_DT_CH1 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Principal Loan Bal Dt |
| 17 | NSLDS_LOAN_START1 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Beginning Date |
| 18 | NSLDS_LOAN_ENDCH1 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Ending Date |
| 19 | NSLDS_GA_CD1 | Character(3) | VARCHAR2(3) NOT NULL | Guarantee Agency |
| 20 | NSLDS_CONTACT_TP1 | Character(3) | VARCHAR2(3) NOT NULL | Contact Type |
| 21 | NSLDS_SCHOOL_CD1 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Original School Code |
| 22 | NSLDS_CONTACT1 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Contact |
| 23 | NSLDS_GRADE_LVL1 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Grade Level |
| 24 | NSLDS_LOAN_SEQCH2 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Seq Nbr |
| 25 | NSLDS_LN_TYPE_CD2 | Character(1) | VARCHAR2(1) NOT NULL |
NSLDS Loan Type Cd
D=Defaulted F=Fraud R=Recent T=Discharged |
| 26 | NSLDS_CHANGE_FLAG2 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Change Flag |
| 27 | NSLDS_LOAN_PGMCD2 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Program Cd |
| 28 | NSLDS_NET_LN_AMT2 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Net Loan Amt |
| 29 | NSLDS_STATUS_CD2 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Current Status Code |
| 30 | NSLDS_STAT_DT_2 | Date(10) | DATE | Loan Status Effective Date |
| 31 | NSLDS_PRIN_BALCH2 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Loan Outstand Prin Bal |
| 32 | NSLDS_BAL_DT_CH2 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Principal Loan Bal Dt |
| 33 | NSLDS_LOAN_START2 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Beginning Date |
| 34 | NSLDS_LOAN_ENDCH2 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Ending Date |
| 35 | NSLDS_GA_CD2 | Character(3) | VARCHAR2(3) NOT NULL | Guarantee Agency |
| 36 | NSLDS_CONTACT_TP2 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Contact Type |
| 37 | NSLDS_SCHOOL_CD2 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Original School Code |
| 38 | NSLDS_CONTACT2 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Contact |
| 39 | NSLDS_GRADE_LVL2 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Grade Level |
| 40 | NSLDS_LOAN_SEQCH3 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Seq Nbr |
| 41 | NSLDS_LN_TYPE_CD3 | Character(1) | VARCHAR2(1) NOT NULL |
NSLDS Loan Type Cd
D=Defaulted F=Fraud R=Recent T=Discharged |
| 42 | NSLDS_CHANGE_FLAG3 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Change Flag |
| 43 | NSLDS_LOAN_PGMCD3 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Program Cd |
| 44 | NSLDS_NET_LN_AMT3 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Net Loan Amt |
| 45 | NSLDS_STATUS_CD3 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Current Status Code |
| 46 | NSLDS_STAT_DT_3 | Date(10) | DATE | Loan Status Effective Date |
| 47 | NSLDS_PRIN_BALCH3 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Loan Outstand Prin Bal |
| 48 | NSLDS_BAL_DT_CH3 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Principal Loan Bal Dt |
| 49 | NSLDS_LOAN_START3 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Beginning Date |
| 50 | NSLDS_LOAN_ENDCH3 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Ending Date |
| 51 | NSLDS_GA_CD3 | Character(3) | VARCHAR2(3) NOT NULL | Guarantee Agency |
| 52 | NSLDS_CONTACT_TP3 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Contact Type |
| 53 | NSLDS_SCHOOL_CD3 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Original School Code |
| 54 | NSLDS_CONTACT3 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Contact |
| 55 | NSLDS_GRADE_LVL3 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Grade Level |
| 56 | NSLDS_LOAN_SEQCH4 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Seq Nbr |
| 57 | NSLDS_LN_TYPE_CD4 | Character(1) | VARCHAR2(1) NOT NULL |
NSLDS Loan Type Cd
D=Defaulted F=Fraud R=Recent T=Discharged |
| 58 | NSLDS_CHANGE_FLAG4 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Change Flag |
| 59 | NSLDS_LOAN_PGMCD4 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Program Cd |
| 60 | NSLDS_NET_LN_AMT4 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Net Loan Amt |
| 61 | NSLDS_STATUS_CD4 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Current Status Code |
| 62 | NSLDS_STAT_DT_4 | Date(10) | DATE | Loan Status Effective Date |
| 63 | NSLDS_PRIN_BALCH4 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Loan Outstand Prin Bal |
| 64 | NSLDS_BAL_DT_CH4 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Principal Loan Bal Dt |
| 65 | NSLDS_LOAN_START4 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Beginning Date |
| 66 | NSLDS_LOAN_ENDCH4 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Ending Date |
| 67 | NSLDS_GA_CD4 | Character(3) | VARCHAR2(3) NOT NULL | Guarantee Agency |
| 68 | NSLDS_CONTACT_TP4 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Contact Type |
| 69 | NSLDS_SCHOOL_CD4 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Original School Code |
| 70 | NSLDS_CONTACT4 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Contact |
| 71 | NSLDS_GRADE_LVL4 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Grade Level |
| 72 | NSLDS_LOAN_SEQCH5 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Seq Nbr |
| 73 | NSLDS_LN_TYPE_CD5 | Character(1) | VARCHAR2(1) NOT NULL |
NSLDS Loan Type Cd
D=Defaulted F=Fraud R=Recent T=Discharged |
| 74 | NSLDS_CHANGE_FLAG5 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Change Flag |
| 75 | NSLDS_LOAN_PGMCD5 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Program Cd |
| 76 | NSLDS_NET_LN_AMT5 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Net Loan Amt |
| 77 | NSLDS_STATUS_CD5 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Current Status Code |
| 78 | NSLDS_STAT_DT_5 | Date(10) | DATE | Loan Status Effective Date |
| 79 | NSLDS_PRIN_BALCH5 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Loan Outstand Prin Bal |
| 80 | NSLDS_BAL_DT_CH5 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Principal Loan Bal Dt |
| 81 | NSLDS_LOAN_START5 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Beginning Date |
| 82 | NSLDS_LOAN_ENDCH5 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Ending Date |
| 83 | NSLDS_GA_CD5 | Character(3) | VARCHAR2(3) NOT NULL | Guarantee Agency |
| 84 | NSLDS_CONTACT_TP5 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Contact Type |
| 85 | NSLDS_SCHOOL_CD5 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Original School Code |
| 86 | NSLDS_CONTACT5 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Contact |
| 87 | NSLDS_GRADE_LVL5 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Grade Level |
| 88 | NSLDS_LOAN_SEQCH6 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Seq Nbr |
| 89 | NSLDS_LN_TYPE_CD6 | Character(1) | VARCHAR2(1) NOT NULL |
NSLDS Loan Type Cd
D=Defaulted F=Fraud R=Recent T=Discharged |
| 90 | NSLDS_CHANGE_FLAG6 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Change Flag |
| 91 | NSLDS_LOAN_PGMCD6 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Loan Program Cd |
| 92 | NSLDS_NET_LN_AMT6 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Net Loan Amt |
| 93 | NSLDS_STATUS_CD6 | Character(2) | VARCHAR2(2) NOT NULL | NSLDS Current Status Code |
| 94 | NSLDS_STAT_DT_6 | Date(10) | DATE | Loan Status Effective Date |
| 95 | NSLDS_PRIN_BALCH6 | Character(6) | VARCHAR2(6) NOT NULL | NSLDS Loan Outstand Prin Bal |
| 96 | NSLDS_BAL_DT_CH6 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Principal Loan Bal Dt |
| 97 | NSLDS_LOAN_START6 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Beginning Date |
| 98 | NSLDS_LOAN_ENDCH6 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Loan Ending Date |
| 99 | NSLDS_GA_CD6 | Character(3) | VARCHAR2(3) NOT NULL | Guarantee Agency |
| 100 | NSLDS_CONTACT_TP6 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Contact Type |
| 101 | NSLDS_SCHOOL_CD6 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Original School Code |
| 102 | NSLDS_CONTACT6 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Contact |
| 103 | NSLDS_GRADE_LVL6 | Character(3) | VARCHAR2(3) NOT NULL | NSLDS Grade Level |
| 104 | NSLDS_LN_EXUSUB_1 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Extra UnSub (1) |
| 105 | NSLDS_LN_EXUSUB_2 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Extra UnSub (2) |
| 106 | NSLDS_LN_EXUSUB_3 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Extra UnSub (3) |
| 107 | NSLDS_LN_EXUSUB_4 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Extra UnSub (4) |
| 108 | NSLDS_LN_EXUSUB_5 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Extra UnSub (5) |
| 109 | NSLDS_LN_EXUSUB_6 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Extra UnSub (6) |
| 110 | NSLDS_LN_CAPINT_1 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Cap Interest (1) |
| 111 | NSLDS_LN_CAPINT_2 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Cap Interest (2) |
| 112 | NSLDS_LN_CAPINT_3 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Cap Interest (3) |
| 113 | NSLDS_LN_CAPINT_4 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Cap Interest (4) |
| 114 | NSLDS_LN_CAPINT_5 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Cap Interest (5) |
| 115 | NSLDS_LN_CAPINT_6 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Cap Interest (6) |
| 116 | NSLDS_LN_DISB_AMT1 | Character(6) | VARCHAR2(6) NOT NULL | Last loan disbursement amount reported on the ISIR file. |
| 117 | NSLDS_LN_DISB_AMT2 | Character(6) | VARCHAR2(6) NOT NULL | Last loan disbursement amount reported on the ISIR file. |
| 118 | NSLDS_LN_DISB_AMT3 | Character(6) | VARCHAR2(6) NOT NULL | Last loan disbursement amount reported on the ISIR file. |
| 119 | NSLDS_LN_DISB_AMT4 | Character(6) | VARCHAR2(6) NOT NULL | Last loan disbursement amount reported on the ISIR file. |
| 120 | NSLDS_LN_DISB_AMT5 | Character(6) | VARCHAR2(6) NOT NULL | Last loan disbursement amount reported on the ISIR file. |
| 121 | NSLDS_LN_DISB_AMT6 | Character(6) | VARCHAR2(6) NOT NULL | Last loan disbursement amount reported on the ISIR file. |
| 122 | NSLDS_LN_DISB_DT_1 | Character(8) | VARCHAR2(8) NOT NULL | Date of Last Loan Disbt (1) |
| 123 | NSLDS_LN_DISB_DT_2 | Character(8) | VARCHAR2(8) NOT NULL | Date of Last Loan Disbt (2) |
| 124 | NSLDS_LN_DISB_DT_3 | Character(8) | VARCHAR2(8) NOT NULL | Date of Last Loan Disbt (3) |
| 125 | NSLDS_LN_DISB_DT_4 | Character(8) | VARCHAR2(8) NOT NULL | Date of Last Loan Disbt (4) |
| 126 | NSLDS_LN_DISB_DT_5 | Character(8) | VARCHAR2(8) NOT NULL | Date of Last Loan Disbt (5) |
| 127 | NSLDS_LN_DISB_DT_6 | Character(8) | VARCHAR2(8) NOT NULL | Date of Last Loan Disbt (6) |
| 128 | SFA_NSLDS_SUB_ST_1 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Subsidy Status (1) |
| 129 | SFA_NSLDS_SUB_ST_2 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Subsidy Status (2) |
| 130 | SFA_NSLDS_SUB_ST_3 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Subsidy Status (3) |
| 131 | SFA_NSLDS_SUB_ST_4 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Subsidy Status (4) |
| 132 | SFA_NSLDS_SUB_ST_5 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Subsidy Status (5) |
| 133 | SFA_NSLDS_SUB_ST_6 | Character(1) | VARCHAR2(1) NOT NULL | NSLDS Loan Subsidy Status (6) |
| 134 | SFA_NSLDS_SUB_DT_1 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Subsidy Status Date (1) |
| 135 | SFA_NSLDS_SUB_DT_2 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Subsidy Status Date (2) |
| 136 | SFA_NSLDS_SUB_DT_3 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Subsidy Status Date (3) |
| 137 | SFA_NSLDS_SUB_DT_4 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Subsidy Status Date (4) |
| 138 | SFA_NSLDS_SUB_DT_5 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Subsidy Status Date (5) |
| 139 | SFA_NSLDS_SUB_DT_6 | Character(8) | VARCHAR2(8) NOT NULL | NSLDS Subsidy Status Date (6) |
| 140 | SFA_NSLDS_ST_DT_1 | Character(8) | VARCHAR2(8) NOT NULL | 2425:NSLDS Loan (1) Loan Academic Start Date |
| 141 | SFA_NSLDS_ST_DT_2 | Character(8) | VARCHAR2(8) NOT NULL | 2425:NSLDS Loan (2) Loan Academic Start Date |
| 142 | SFA_NSLDS_ST_DT_3 | Character(8) | VARCHAR2(8) NOT NULL | 2425:NSLDS Loan (3) Loan Academic Start Date |
| 143 | SFA_NSLDS_ST_DT_4 | Character(8) | VARCHAR2(8) NOT NULL | 2425:NSLDS Loan (4) Loan Academic Start Date |
| 144 | SFA_NSLDS_ST_DT_5 | Character(8) | VARCHAR2(8) NOT NULL | 2425:NSLDS Loan (5) Loan Academic Start Date |
| 145 | SFA_NSLDS_ST_DT_6 | Character(8) | VARCHAR2(8) NOT NULL | 2425:NSLDS Loan (6) Loan Academic Start Date |