FA_PRCSDEMO_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FA_PROCESS_NAME |
Character(1) | VARCHAR2(1) NOT NULL |
Financial Aid Process
A=Award Notification I=ISIR Processing L=Loan Processing |
| 2 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |
| 3 | FA_PERM_ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Addr Usage Perm
Prompt Table: ADDR_USAGE_TBL |
| 4 | FA_MAIL_ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Addr Usage Mail
Prompt Table: ADDR_USAGE_TBL |
| 5 | NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Name Usage
Prompt Table: NAME_USAGE_VW |
| 6 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 7 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
| 8 | ISIR_PHONE_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Phone Usage
Prompt Table: ISIR_P_USAGE_VW |
| 9 | ISIR_E_ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Email Usage
Prompt Table: ISIR_E_USAGE_VW |