| # |
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 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 7 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 8 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 9 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 10 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 11 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 12 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 13 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 14 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 15 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 16 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 17 |
MAR_STATUS_DT |
Date(10) |
DATE |
This is the date that the employee's Marital status is/was effective.
/* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons.
1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user.
2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
|
| 18 |
SFA_CR_BIRTH_DT |
Character(10) |
VARCHAR2(10) NOT NULL |
Birthdate
|
| 19 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table:
HCR_CTZN_STS_I
|
| 20 |
VISA_WRKPMT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Visa/Permit Number
|
| 21 |
DRIVERS_LIC_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
Driver's License #
|
| 22 |
DRIV_LIC_STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Issuing State
|
| 23 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 24 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 25 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 26 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 27 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 28 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 29 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 30 |
SFA_PF_SCHL_PERID |
Character(20) |
VARCHAR2(20) NOT NULL |
School Assigned Person ID
|
| 31 |
PREF_FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Preferred First Name
|
| 32 |
SFA_PF_CBFINAID_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
CB FinAid ID
|