INSTITUTIONAID_YEARSFA_VERIF_MAR_ALL1=Never Married
10=Unmarried
2=Single
3=Married
4=Remarried
5=Married/Remarried
6=Divorced
7=Separated
8=Divorced/Separated
9=Widowed
1=Never Married
2=Married
3=Remarried
4=Separated
5=Divorced
6=Widowed
SFA_VER_MAR_MAP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 3 | SFA_VERIF_MAR_ALL |
Character(2) | VARCHAR2(2) NOT NULL |
Used in Verification to display all possible marital status for mapping
1=Never Married 10=Unmarried 2=Single 3=Married 4=Remarried 5=Married/Remarried 6=Divorced 7=Separated 8=Divorced/Separated 9=Widowed |
| 4 | SFA_VE_MARITAL_MAP | Character(1) | VARCHAR2(1) NOT NULL |
Used in Verification for display of mapped marital status
1=Never Married 2=Married 3=Remarried 4=Separated 5=Divorced 6=Widowed |