INST_REPORT_VW(SQL View) |
Index Back |
---|---|
IM App Load Summary VWThis is a view which can be used for IM application load reporting. |
SELECT A.EMPLID , A.INSTITUTION , A.AID_YEAR , A.APP_SOURCE_CODE , B.NAME , C.NATIONAL_ID , A.DT_APP_RECEIVED , A.DT_APP_COMPLETED , A.SIGNED_BY_APPLICNT , A.SIGNED_BY_FATHER , A.SIGNED_BY_MOTHER , A.SIGNED_BY_SPOUSE , A.SPECIAL_PROCESSING , A.INAS_RFC_CALL , A.CSS_ID , A.CSS_SCHOOL_CODE , A.CPS_SCHOOL_CODE , A.CNAS_RFC_CALL , A.SIGNED_ELECTRONIC , A.DT_APP_LOADED , D.NUMBER_EXEMPTIONS , D.NUM_FAMILY_MEMBERS FROM PS_INST_CONTROL A , PS_HCR_PERSON_NM_I B , PS_HCR_PER_NID_I C , PS_INST_STUDENT D WHERE B.EMPLID = A.EMPLID AND C.EMPLID = B.EMPLID AND D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.APP_SOURCE_CODE = A.APP_SOURCE_CODE |
# | 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: STUDENT_AID |
4 | APP_SOURCE_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Application Source Code
0=Need Access 0=Need Access 1=Electronic Initial Application 2=Electronic Renewal Aplication 3=Electronic Correction 4=FAFSA Express 5=ACT 6=I-NET 7=NCS 8=Profile 9=Institutional Application O=FT Canada Student Loan P=PT Canada Student Loan |
5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
6 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
7 | DT_APP_RECEIVED | Date(10) | DATE |
Date Application Received
Default Value: %date |
8 | DT_APP_COMPLETED | Date(10) | DATE | Date Application Completed |
9 | SIGNED_BY_APPLICNT | Character(1) | VARCHAR2(1) NOT NULL |
Student Signed
1=Yes 2=No |
10 | SIGNED_BY_FATHER | Character(1) | VARCHAR2(1) NOT NULL |
Father Signed
1=Yes |
11 | SIGNED_BY_MOTHER | Character(1) | VARCHAR2(1) NOT NULL |
Mother Signed
1=Yes |
12 | SIGNED_BY_SPOUSE | Character(1) | VARCHAR2(1) NOT NULL |
Spouse Signed
1=Yes |
13 | SPECIAL_PROCESSING | Character(1) | VARCHAR2(1) NOT NULL |
Special Circumstances
1=Yes N=No Y=Yes |
14 | INAS_RFC_CALL | Character(1) | VARCHAR2(1) NOT NULL |
Calc EFC via Remote Call
N=No Y=Yes |
15 | CSS_ID | Character(7) | VARCHAR2(7) NOT NULL | CSS ID Number |
16 | CSS_SCHOOL_CODE | Character(4) | VARCHAR2(4) NOT NULL | CSS School Code |
17 | CPS_SCHOOL_CODE | Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
18 | CNAS_RFC_CALL | Character(1) | VARCHAR2(1) NOT NULL | Call CNAS via RFC |
19 | SIGNED_ELECTRONIC | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Signature
1=Yes |
20 | DT_APP_LOADED | Date(10) | DATE | Date Application Loaded |
21 | NUMBER_EXEMPTIONS | Character(2) | VARCHAR2(2) NOT NULL |
Nbr of Exemptions
00=00 01=01 02=02 03=03 04=04 05=05 06=06 07=07 08=08 09=09 1=1 10=10 11=11 12=12 2=2 3=3 4=4 5=5 6=6 7=7 8=8 9=9 ?=? |
22 | NUM_FAMILY_MEMBERS | Character(2) | VARCHAR2(2) NOT NULL | Nbr in Family |