BENEFITS PCCS Table
View exposing PCCS benefits application and subsidy detail including employee, spouse, child, income, contribution, and application-status attributes used for benefits administration and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
APPLICATION_STATUS_CODE |
Code identifying application status. |
VARCHAR2 |
1 |
APPLICATION_STATUS_DESC |
Description of application status. |
VARCHAR2 |
18 |
BEGIN_DATE |
Date associated with begin. |
DATE |
|
BENEFITS_RECIPIENT_KEY |
Surrogate key identifying the benefits recipient. |
VARCHAR2 |
14 |
CHILD_SEQ_NUMBER |
Child seq number as provided by the source. |
VARCHAR2 |
2 |
CHILD_SUBTYPE |
Child subtype as provided by the source. |
VARCHAR2 |
4 |
EE_ADDTL_INC |
Ee addtl inc as provided by the source. |
NUMBER |
15,2 |
EE_CONTR_AMT |
Ee contr amt as provided by the source. |
NUMBER |
13,2 |
EE_GROSS_INC |
Ee gross inc as provided by the source. |
NUMBER |
15,2 |
END_DATE |
Date associated with end. |
DATE |
|
ER_NOTAX_SUB |
Er notax sub as provided by the source. |
NUMBER |
13,2 |
ER_TAXED_SUB |
Er taxed sub as provided by the source. |
NUMBER |
13,2 |
LAST_CHANGED_DATE |
Date associated with last changed. |
DATE |
|
LAST_CHANGED_NAME |
Last changed name as provided by the source. |
VARCHAR2 |
12 |
MARITAL_STATUS_CODE |
Code identifying marital status. |
VARCHAR2 |
1 |
MARITAL_STATUS_DESC |
Description of marital status. |
VARCHAR2 |
25 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
RECORD_TYPE |
Record type as provided by the source. |
VARCHAR2 |
10 |
SP_ADDTL_INC |
Sp addtl inc as provided by the source. |
NUMBER |
15,2 |
SP_EMPLOYER |
Sp employer as provided by the source. |
VARCHAR2 |
60 |
SP_EMPLOYMENT_STATUS_CODE |
Code identifying sp employment status. |
VARCHAR2 |
1 |
SP_EMPLOYMENT_STATUS_DESC |
Description of sp employment status. |
VARCHAR2 |
18 |
SP_FIRST_NAME |
Sp first name as provided by the source. |
VARCHAR2 |
25 |
SP_GRAD_DATE |
Date associated with sp grad. |
DATE |
|
SP_GROSS_INC |
Sp gross inc as provided by the source. |
NUMBER |
15,2 |
SP_LAST_NAME |
Sp last name as provided by the source. |
VARCHAR2 |
25 |
SP_MIT_ID |
Business identifier for the sp mit. |
VARCHAR2 |
9 |
SP_SCHOOL |
Sp school as provided by the source. |
VARCHAR2 |
60 |