BEN_EXTRACT_DETAILS_ARCH
This table holds the archived data from BEN_EXTRACT_REQ_DETAILS table.
Details
-
Schema: FUSION
-
Object owner: BEN
-
Object type: TABLE
-
Tablespace: ARCHIVE
Primary Key
| Name | Columns |
|---|---|
|
BEN_EXTRACT_DETAILS_ARCH_PK |
REQUEST_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_DETAIL_ID | NUMBER | 18 | Yes | REQUEST_DETAIL_ID | |
| EXT_REQUEST_ID | NUMBER | 18 | Yes | Identifies the Extarct request associated with this request detail. | |
| ENTERPRISE_ID | NUMBER | 18 | Yes | identifies enterprise | |
| PARENT_REQUEST_DETAIL_ID | NUMBER | 18 | PARENT_REQUEST_DETAIL_ID | ||
| PERSON_ID | NUMBER | 18 | Yes | PERSON_ID | |
| CARRIER_ID | NUMBER | 18 | CARRIER_ID | ||
| FIRST_NAME | VARCHAR2 | 240 | FIRST_NAME | ||
| LAST_NAME | VARCHAR2 | 240 | LAST_NAME | ||
| MIDDLE_NAME | VARCHAR2 | 240 | MIDDLE_NAME | ||
| SUFFIX | VARCHAR2 | 240 | SUFFIX | ||
| GENDER_FLAG | VARCHAR2 | 30 | GENDER_FLAG | ||
| NATIONAL_IDENTIFIER | VARCHAR2 | 30 | NATIONAL_IDENTIFIER | ||
| DATE_OF_BIRTH | DATE | DATE_OF_BIRTH | |||
| DATE_OF_DEATH | DATE | DATE_OF_DEATH | |||
| TERMINATION_DATE | DATE | TERMINATION_DATE | |||
| MARITAL_STATUS | VARCHAR2 | 30 | MARITAL_STATUS | ||
| TOBACCO_USER | VARCHAR2 | 30 | TOBACCO_USER | ||
| DISABLED_FLAG | VARCHAR2 | 30 | DISABLED_FLAG | ||
| STUDENT_STATUS | VARCHAR2 | 30 | STUDENT_STATUS | ||
| EMAIL_ADDRESS_ID | VARCHAR2 | 60 | EMAIL_ADDRESS_ID | ||
| EMPLOYEE_ID | NUMBER | 18 | EMPLOYEE_ID | ||
| EMPLOYMENT_ORGANIZATION | VARCHAR2 | 240 | EMPLOYMENT_ORGANIZATION | ||
| EMPLOYMENT_STATUS | VARCHAR2 | 60 | EMPLOYMENT_STATUS | ||
| HIRE_DATE | DATE | HIRE_DATE | |||
| ORIGINAL_DATE_OF_HIRE | DATE | ORIGINAL_DATE_OF_HIRE | |||
| JOB | VARCHAR2 | 60 | JOB | ||
| GRADE | VARCHAR2 | 60 | GRADE | ||
| PAYROLL | VARCHAR2 | 80 | PAYROLL | ||
| BASE_SALARY | NUMBER | BASE_SALARY | |||
| TRANSACTION_CODE | VARCHAR2 | 60 | TRANSACTION_CODE | ||
| HOME_ADDRESS_LINE1 | VARCHAR2 | 80 | HOME_ADDRESS_LINE1 | ||
| HOME_ADDRESS_LINE2 | VARCHAR2 | 80 | HOME_ADDRESS_LINE2 | ||
| HOME_CITY | VARCHAR2 | 80 | HOME_CITY | ||
| HOME_STATE | VARCHAR2 | 80 | HOME_STATE | ||
| HOME_ZIP_CODE | VARCHAR2 | 80 | HOME_ZIP_CODE | ||
| HOME_PHONE | VARCHAR2 | 80 | HOME_PHONE | ||
| WORK_ADDRESS_LINE1 | VARCHAR2 | 80 | WORK_ADDRESS_LINE1 | ||
| WORK_ADDRESS_LINE2 | VARCHAR2 | 80 | WORK_ADDRESS_LINE2 | ||
| WORK_CITY | VARCHAR2 | 80 | WORK_CITY | ||
| WORK_STATE | VARCHAR2 | 80 | WORK_STATE | ||
| WORK_ZIP_CODE | VARCHAR2 | 80 | WORK_ZIP_CODE | ||
| WORK_PHONE | VARCHAR2 | 80 | WORK_PHONE | ||
| PLAN | VARCHAR2 | 80 | PLAN | ||
| LEVEL_NAME | VARCHAR2 | 80 | LEVEL_NAME | ||
| LEVEL_CVG_START_DATE | DATE | LEVEL_CVG_START_DATE | |||
| LEVEL_CVG_END_DATE | DATE | LEVEL_CVG_END_DATE | |||
| COVERAGE_START_DATE | DATE | COVERAGE_START_DATE | |||
| COVERAGE_END_DATE | DATE | COVERAGE_END_DATE | |||
| COVERAGE_AMOUNT_APPROVED | NUMBER | COVERAGE_AMOUNT_APPROVED | |||
| COVERAGE_AMOUNT_PENDING | NUMBER | COVERAGE_AMOUNT_PENDING | |||
| FSA_PLAN_YEAR | NUMBER | FSA_PLAN_YEAR | |||
| FSA_ANNUAL_TARGET | NUMBER | FSA_ANNUAL_TARGET | |||
| DIRECT_DEPOSIT_ROUTING | NUMBER | DIRECT_DEPOSIT_ROUTING | |||
| DIRECT_DEPOST_ACCOUNT | VARCHAR2 | 30 | DIRECT_DEPOST_ACCOUNT | ||
| EE_PRETAX_COST | NUMBER | EE_PRETAX_COST | |||
| EE_POSTTAX_COST | NUMBER | EE_POSTTAX_COST | |||
| EE_TOTAL_COST | NUMBER | EE_TOTAL_COST | |||
| PROVIDER_ID | VARCHAR2 | 30 | PROVIDER_ID | ||
| PROVIDER_NAME | VARCHAR2 | 60 | PROVIDER_NAME | ||
| PROVIDER_START_DATE | DATE | PROVIDER_START_DATE | |||
| DPNT_RELATIONSHIP_TYPE | VARCHAR2 | 60 | DPNT_RELATIONSHIP_TYPE | ||
| DPNT_FULL_TIME_STUDENT | VARCHAR2 | 30 | DPNT_FULL_TIME_STUDENT | ||
| ORGANIZATION_IDENTIFIER | VARCHAR2 | 255 | ORGANIZATION_IDENTIFIER | ||
| DEP_NAME | VARCHAR2 | 255 | DEP_NAME | ||
| MARITAL_STATUS_START_DATE | DATE | MARITAL_STATUS_START_DATE | |||
| TIER_COVERAGE_TYPE | VARCHAR2 | 80 | TIER_COVERAGE_TYPE | ||
| EMPLOYMENT_LEVEL_CODE | VARCHAR2 | 80 | EMPLOYMENT_LEVEL_CODE | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| BEN_EXTRACT_DETAILS_ARCH_U1 | Unique | Default | REQUEST_DETAIL_ID |