SCC_HE_MARITAL

(SQL Table)
Index Back

Marital Status Mappings

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 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

Prompt Table: SSR_HE_MARSTAVW

3 SSR_HE_MAR_STATUS Character(2) VARCHAR2(2) NOT NULL HESA Marital Status

Prompt Table: SSR_HE_CODE_VW

4 SSR_HE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

Y/N Table Edit

Default Value: Y

5 SCC_HE_MARSTATE Character(2) VARCHAR2(2) NOT NULL HESA Marital Status

Prompt Table: SCC_HE_MARS_VW