EMPLIDPrompt Table: STDNT_AID_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
AID_YEARPrompt Table: FED_AID_YR_TBL
EFFDTDefault Value: %date
EFFSEQREJECT_REASONSFA_NAC_ASREJ_CDLANGUAGE_CDSFA_REJCLN_VW1(SQL View) |
Index Back |
|---|---|
ISIR Reject Reason Lng ViewThis table contains the ISIR reject reason codes along with their descriptions. |
| SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.EFFDT , A.EFFSEQ , A.REJECT_REASON , A.SFA_NAC_ASREJ_CD , B.LANGUAGE_CD , B.DESCRLONG FROM PS_ISIR_REJ_REASON A ,PS_ISIR_REJECT_LNG B WHERE A.AID_YEAR = B.AID_YEAR AND A.REJECT_REASON = B.REJECT_REASON AND A.SFA_NAC_ASREJ_CD = B.SFA_NAC_ASREJ_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STDNT_AID_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: FED_AID_YR_TBL |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | REJECT_REASON |
Character(2) | VARCHAR2(2) NOT NULL | Reject Reason |
| 7 | SFA_NAC_ASREJ_CD |
Character(4) | VARCHAR2(4) NOT NULL | NAC Reject Code |
| 8 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 9 | DESCRLONG | Long Character | CLOB | Long Description |