1. Tables and Views for HCM
  2. BEN_CRT_ORDR_F

BEN_CRT_ORDR_F

BEN_CRT_ORDR_F identifies orders issued by legislative bodies for a person and a plan or a plan type. A person may have multiple orders for the same plan covering different related persons.

Details

  • Schema: FUSION

  • Object owner: BEN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

BEN_CRT_ORDR_F_PK

CRT_ORDR_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
CRT_ORDR_ID NUMBER 18 Yes System generated primary key column.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
CRT_ORDR_TYP_CD VARCHAR2 30 Yes This column indicates Court order type.
CRT_ORDR_STAT_CD VARCHAR2 30 Yes Court order status to determine if it is to be enforced or not.
BUSINESS_GROUP_ID NUMBER 18 Yes Foreign key to HR_ORGANIZATION_UNITS.
ORDR_END_DATE DATE This column indicates Court Order ending date.
ORDR_START_DATE DATE Yes This column indicates Court order starting date.
CRT_IDENT VARCHAR2 240 This column indicates Court order identifier.
DESCRIPTION VARCHAR2 600 This column indicates the Description.
DETD_QLFD_ORDR_DT DATE Determined qualified court order date.
ISSUE_DT DATE This column indicates the Issue date.
PERSON_ID NUMBER 18 Yes Foreign Key to PER_ALL_PEOPLE_F.
RCVD_DT DATE This column indicates Received Date.
CRT_ISSNG VARCHAR2 240 This column indicates Issuing Court.
ELIGIBLE_DT DATE This column indicates Eligible Date.
PASSD_FIN_ASSMNT VARCHAR2 30 This column indicates Passed Financial assessment.
ADDRESS_LINE_1 VARCHAR2 240 This column indicates First line of address.
ADDRESS_LINE_2 VARCHAR2 240 This column indicates Second line of address.
ADDRESS_LINE_3 VARCHAR2 240 This column indicates Third line of address.
ADDRESS_LINE_4 VARCHAR2 240 This column indicates Fourth line of address.
COUNTRY VARCHAR2 60 This column indicates Country of the address.
POSTAL_CODE VARCHAR2 30 This column indicates Postal code of the address.
CITY VARCHAR2 30 This column indicates City of the address.
STATE VARCHAR2 60 This column indicates State of the address.
NOTES VARCHAR2 4000 This column indicates the Notes.
CRT_ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield structure defining column.
CRT_ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield segment column.
CRT_ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE13 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE14 DATE Descriptive Flexfield: segment of the descriptive flexfield.
CRT_ATTRIBUTE_DATE15 DATE Descriptive Flexfield: segment of the descriptive flexfield.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
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.
CONFIG_ID_1 NUMBER 18 Template ID field for future use.
CONFIG_ID_2 NUMBER 18 Template ID field for future use.
CONFIG_ID_3 NUMBER 18 Template ID field for future use.
CONFIG_ID_4 NUMBER 18 Template ID field for future use.
CONFIG_ID_5 NUMBER 18 Template ID field for future use.
CONFIG_ID_6 NUMBER 18 Template ID field for future use.
CONFIG_ID_7 NUMBER 18 Template ID field for future use.
CONFIG_ID_8 NUMBER 18 Template ID field for future use.
CONFIG_ID_9 NUMBER 18 Template ID field for future use.
CONFIG_ID_10 NUMBER 18 Template ID field for future use.
CONFIG_NUM_1 NUMBER Template number field for future use.
CONFIG_NUM_2 NUMBER Template number field for future use.
CONFIG_NUM_3 NUMBER Template number field for future use.
CONFIG_NUM_4 NUMBER Template number field for future use.
CONFIG_NUM_5 NUMBER Template number field for future use.
CONFIG_NUM_6 NUMBER Template number field for future use.
CONFIG_NUM_7 NUMBER Template number field for future use.
CONFIG_NUM_8 NUMBER Template number field for future use.
CONFIG_NUM_9 NUMBER Template number field for future use.
CONFIG_NUM_10 NUMBER Template number field for future use.
CONFIG_CHAR_1 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_2 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_3 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_4 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_5 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_6 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_7 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_8 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_9 VARCHAR2 240 Template character field for future use.
CONFIG_CHAR_10 VARCHAR2 240 Template character field for future use.
CONFIG_DATE_1 DATE Template date field for future use.
CONFIG_DATE_2 DATE Template date field for future use.
CONFIG_DATE_3 DATE Template date field for future use.
CONFIG_DATE_4 DATE Template date field for future use.
CONFIG_DATE_5 DATE Template date field for future use.
CONFIG_DATE_6 DATE Template date field for future use.
CONFIG_DATE_7 DATE Template date field for future use.
CONFIG_DATE_8 DATE Template date field for future use.
CONFIG_DATE_9 DATE Template date field for future use.
CONFIG_DATE_10 DATE Template date field for future use.

Indexes

Index Uniqueness Tablespace Columns
BEN_CRT_ORDR_F_N1 Non Unique Default PERSON_ID, CRT_ORDR_TYP_CD, CRT_ORDR_STAT_CD
BEN_CRT_ORDR_F_PK Unique Default CRT_ORDR_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE