LN_DL_CHG_XREF(SQL Table) |
Index Back |
---|---|
Direct Loan Change # XREFdl_chg_xref is used as a cross reference between the SAR (Student Aid Report) question numbers and the ISIR tables that store the information. This cross reference is used when making electronic corrections to the ISIR data, and the SAR field number is required for those changes. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: FED_AID_YR_TBL |
2 | DL_CHG_FIELD_NBR | Character(4) | VARCHAR2(4) NOT NULL | Direct Loan Chg Field Number |
3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: LN_TBL_VW |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: LN_DL_CHG_XREF.DESCR |
7 | DL_CHG_FLD_LENGTH | Number(2,0) | SMALLINT NOT NULL | Direct Loan Field Length |
8 | DL_CHG_FLD_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Direct Loan Field Type
A=Alpha AN=Alphanumeric D=Date N=Number SN=Signed Number |
9 | CHG_FLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Change Field Status
A=Active I=Inactive Default Value: A |
10 | DL_CHG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DL Change Type
D=Demographic E=Eligibility F=Financial T=Date |