SFA_PF_ADDR_ST(SQL Table) |
Index Back |
|---|---|
Stage Stdnt Address stageTblThis record houses Address data in the Staging tables. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SFA_PF_QUEUE_INST |
Number(9,0) | DECIMAL(9) NOT NULL | Load Instance |
| 2 | CSS_ID |
Character(7) | VARCHAR2(7) NOT NULL | CSS ID Number |
| 3 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 4 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
| 5 | 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 |
| 6 | ADDRESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 8 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 9 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 10 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 12 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 13 | SFA_PF_FADDR_IND | Character(1) | VARCHAR2(1) NOT NULL | Foreign Address Indicator |
| 14 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |