BEN_EXTRACT_REQ_DETAILS
This table holds the extracted data from the extract process. The details of the person(s), plans and various other person data is extracted during ectract process and is stored in this table to be transmited to the plan carrier.
Details
-
Schema: FUSION
-
Object owner: BEN
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
BEN_EXTRACT_REQ_DETAILS_PK |
REQUEST_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_DETAIL_ID | NUMBER | 18 | Yes | REQUEST_DETAIL_ID | |
| PERSON_NUMBER | VARCHAR2 | 80 | PERSON_NUMBER | ||
| EXT_ATTRIBUTE1 | VARCHAR2 | 255 | EXT_ATTRIBUTE1 | ||
| EXT_ATTRIBUTE2 | VARCHAR2 | 255 | EXT_ATTRIBUTE2 | ||
| EXT_ATTRIBUTE3 | VARCHAR2 | 255 | EXT_ATTRIBUTE3 | ||
| EXT_ATTRIBUTE4 | VARCHAR2 | 255 | EXT_ATTRIBUTE4 | ||
| EXT_ATTRIBUTE5 | VARCHAR2 | 255 | EXT_ATTRIBUTE5 | ||
| EXT_ATTRIBUTE6 | VARCHAR2 | 255 | EXT_ATTRIBUTE6 | ||
| EXT_ATTRIBUTE7 | VARCHAR2 | 255 | EXT_ATTRIBUTE7 | ||
| EXT_ATTRIBUTE8 | VARCHAR2 | 255 | EXT_ATTRIBUTE8 | ||
| EXT_ATTRIBUTE9 | VARCHAR2 | 255 | EXT_ATTRIBUTE9 | ||
| EXT_ATTRIBUTE10 | VARCHAR2 | 255 | EXT_ATTRIBUTE10 | ||
| EXT_ATTRIBUTE11 | VARCHAR2 | 255 | EXT_ATTRIBUTE11 | ||
| EXT_ATTRIBUTE12 | VARCHAR2 | 255 | EXT_ATTRIBUTE12 | ||
| EXT_ATTRIBUTE13 | VARCHAR2 | 255 | EXT_ATTRIBUTE13 | ||
| EXT_ATTRIBUTE14 | VARCHAR2 | 255 | EXT_ATTRIBUTE14 | ||
| EXT_ATTRIBUTE15 | VARCHAR2 | 255 | EXT_ATTRIBUTE15 | ||
| EXT_ATTRIBUTE16 | VARCHAR2 | 255 | EXT_ATTRIBUTE16 | ||
| EXT_ATTRIBUTE17 | VARCHAR2 | 255 | EXT_ATTRIBUTE17 | ||
| EXT_ATTRIBUTE18 | VARCHAR2 | 255 | EXT_ATTRIBUTE18 | ||
| EXT_ATTRIBUTE19 | VARCHAR2 | 255 | EXT_ATTRIBUTE19 | ||
| EXT_ATTRIBUTE20 | VARCHAR2 | 255 | EXT_ATTRIBUTE20 | ||
| EXT_ATTRIBUTE21 | VARCHAR2 | 255 | EXT_ATTRIBUTE21 | ||
| EXT_ATTRIBUTE22 | VARCHAR2 | 255 | EXT_ATTRIBUTE22 | ||
| EXT_ATTRIBUTE23 | VARCHAR2 | 255 | EXT_ATTRIBUTE23 | ||
| EXT_ATTRIBUTE24 | VARCHAR2 | 255 | EXT_ATTRIBUTE24 | ||
| EXT_ATTRIBUTE25 | VARCHAR2 | 255 | EXT_ATTRIBUTE25 | ||
| EXT_ATTRIBUTE26 | VARCHAR2 | 255 | EXT_ATTRIBUTE26 | ||
| EXT_ATTRIBUTE27 | VARCHAR2 | 255 | EXT_ATTRIBUTE27 | ||
| EXT_ATTRIBUTE28 | VARCHAR2 | 255 | EXT_ATTRIBUTE28 | ||
| EXT_ATTRIBUTE29 | VARCHAR2 | 255 | EXT_ATTRIBUTE29 | ||
| EXT_ATTRIBUTE30 | VARCHAR2 | 255 | EXT_ATTRIBUTE30 | ||
| EXT_ATTRIBUTE31 | VARCHAR2 | 255 | EXT_ATTRIBUTE31 | ||
| EXT_ATTRIBUTE32 | VARCHAR2 | 255 | EXT_ATTRIBUTE32 | ||
| EXT_ATTRIBUTE33 | VARCHAR2 | 255 | EXT_ATTRIBUTE33 | ||
| EXT_ATTRIBUTE34 | VARCHAR2 | 255 | EXT_ATTRIBUTE34 | ||
| EXT_ATTRIBUTE35 | VARCHAR2 | 255 | EXT_ATTRIBUTE35 | ||
| EXT_ATTRIBUTE36 | VARCHAR2 | 255 | EXT_ATTRIBUTE36 | ||
| EXT_ATTRIBUTE37 | VARCHAR2 | 255 | EXT_ATTRIBUTE37 | ||
| EXT_ATTRIBUTE38 | VARCHAR2 | 255 | EXT_ATTRIBUTE38 | ||
| EXT_ATTRIBUTE39 | VARCHAR2 | 255 | EXT_ATTRIBUTE39 | ||
| EXT_ATTRIBUTE40 | VARCHAR2 | 255 | EXT_ATTRIBUTE40 | ||
| EXT_ATTRIBUTE41 | VARCHAR2 | 255 | EXT_ATTRIBUTE41 | ||
| EXT_ATTRIBUTE42 | VARCHAR2 | 255 | EXT_ATTRIBUTE42 | ||
| EXT_ATTRIBUTE43 | VARCHAR2 | 255 | EXT_ATTRIBUTE43 | ||
| EXT_ATTRIBUTE44 | VARCHAR2 | 255 | EXT_ATTRIBUTE44 | ||
| EXT_ATTRIBUTE45 | VARCHAR2 | 255 | EXT_ATTRIBUTE45 | ||
| EXT_ATTRIBUTE46 | VARCHAR2 | 255 | EXT_ATTRIBUTE46 | ||
| EXT_ATTRIBUTE47 | VARCHAR2 | 255 | EXT_ATTRIBUTE47 | ||
| EXT_ATTRIBUTE48 | VARCHAR2 | 255 | EXT_ATTRIBUTE48 | ||
| EXT_ATTRIBUTE49 | VARCHAR2 | 255 | EXT_ATTRIBUTE49 | ||
| EXT_ATTRIBUTE50 | VARCHAR2 | 255 | EXT_ATTRIBUTE50 | ||
| EXT_REQUEST_ID | NUMBER | 18 | Yes | Identifies the Extarct request associated with this request detail. | |
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| 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 | 240 | JOB | ||
| GRADE | VARCHAR2 | 240 | GRADE | ||
| PAYROLL | VARCHAR2 | 80 | PAYROLL | ||
| BASE_SALARY | NUMBER | BASE_SALARY | |||
| TRANSACTION_CODE | VARCHAR2 | 60 | TRANSACTION_CODE | ||
| HOME_ADDRESS_LINE1 | VARCHAR2 | 240 | HOME_ADDRESS_LINE1 | ||
| HOME_ADDRESS_LINE2 | VARCHAR2 | 240 | 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 | 240 | WORK_ADDRESS_LINE1 | ||
| WORK_ADDRESS_LINE2 | VARCHAR2 | 240 | 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 | 240 | PLAN | ||
| LEVEL_NAME | VARCHAR2 | 240 | 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. | |
| ASSIGNMENT_ID | NUMBER | 18 | References per_all_assignments_m | ||
| BENEFIT_RELATION_ID | NUMBER | 18 | BENEFIT_RELATION_ID | ||
| PGM_ID | NUMBER | 18 | References BEN_PGM_F | ||
| PL_ID | NUMBER | 18 | References BEN_PL_F | ||
| OPT_ID | NUMBER | 18 | References BEN_OPT_F | ||
| PL_TYP_ID | NUMBER | 18 | References BEN_PL_TYP_F. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| BEN_EXTRACT_REQ_DETAILS_N1 | Non Unique | Default | CARRIER_ID |
| BEN_EXTRACT_REQ_DETAILS_N2 | Non Unique | Default | PERSON_ID |
| BEN_EXTRACT_REQ_DETAILS_N3 | Non Unique | Default | PARENT_REQUEST_DETAIL_ID |
| BEN_EXTRACT_REQ_DETAILS_N4 | Non Unique | Default | EXT_REQUEST_ID |
| BEN_EXTRACT_REQ_DETAILS_U1 | Unique | Default | REQUEST_DETAIL_ID |