Oracle Fusion · Data dictionary
HR_DOCUMENT_TYPES_B
HCMUsed in 0 subject areas120 reporting columnsBICC incremental-ready
HR / Workforce (HR), type / category reference.
Likely primary key: DOCUMENT_TYPE_CODE (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): DOCUMENT_TYPE_CODE → PO_DOCUMENT_TYPES_VL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVE_INACTIVE_FLAG | ● | Indicator (Y/N) for the active inactive. | |
| ARCHIVE_CRITERIA_BASIS | ● | Archive criteria basis. | |
| ARCHIVE_CRITERIA_DAYS | ● | Archive criteria days. | |
| AUTHORIZATION_REQUIRED | ● | Authorization required. | |
| BI_REPORT_PATH | ● | Bi report path. | |
| CATEGORY_CODE | ● | Code identifying the category. | |
| COMMENTS_REQUIRED | ● | Comments required. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DATE_FROM_REQUIRED | ● | Date from required. | |
| DATE_TO_REQUIRED | ● | Date to required. | |
| DFF_CTX_SEG_DEFAULT_VALUE | ● | Dff ctx segment default value. | |
| DFF_CTX_SEG_DISPLAY_PREF | ● | Dff ctx segment display pref. | |
| DFF_GLB_SEG_DISPLAY_PREF | ● | Dff glb segment display pref. | |
| DOCUMENT_NAME_REQUIRED | ● | Document name required. | |
| DOCUMENT_NUMBER_REQUIRED | ● | Document number required. | |
| DOCUMENT_TYPE_CODE | PK? | ○ | Code identifying the document type. |
| DOCUMENT_TYPE_ID | ● | Identifier for the document type. | |
| DOCUMENT_TYPE_LEVEL | ● | Document type level. | |
| DT_ATTRIBUTE1 | ● | Date attribute1. | |
| DT_ATTRIBUTE10 | ● | Date attribute10. | |
| DT_ATTRIBUTE2 | ● | Date attribute2. | |
| DT_ATTRIBUTE3 | ● | Date attribute3. | |
| DT_ATTRIBUTE4 | ● | Date attribute4. | |
| DT_ATTRIBUTE5 | ● | Date attribute5. | |
| DT_ATTRIBUTE6 | ● | Date attribute6. | |
| DT_ATTRIBUTE7 | ● | Date attribute7. | |
| DT_ATTRIBUTE8 | ● | Date attribute8. | |
| DT_ATTRIBUTE9 | ● | Date attribute9. | |
| DT_ATTRIBUTE_CATEGORY | ● | Date attribute category. | |
| DT_ATTRIBUTE_DATE1 | ● | Date attribute date1. | |
| DT_ATTRIBUTE_DATE10 | ● | Date attribute date10. | |
| DT_ATTRIBUTE_DATE2 | ● | Date attribute date2. | |
| DT_ATTRIBUTE_DATE3 | ● | Date attribute date3. | |
| DT_ATTRIBUTE_DATE4 | ● | Date attribute date4. | |
| DT_ATTRIBUTE_DATE5 | ● | Date attribute date5. | |
| DT_ATTRIBUTE_DATE6 | ● | Date attribute date6. | |
| DT_ATTRIBUTE_DATE7 | ● | Date attribute date7. | |
| DT_ATTRIBUTE_DATE8 | ● | Date attribute date8. | |
| DT_ATTRIBUTE_DATE9 | ● | Date attribute date9. | |
| DT_ATTRIBUTE_NUMBER1 | ● | Date attribute number1. | |
| DT_ATTRIBUTE_NUMBER10 | ● | Date attribute number10. | |
| DT_ATTRIBUTE_NUMBER2 | ● | Date attribute number2. | |
| DT_ATTRIBUTE_NUMBER3 | ● | Date attribute number3. | |
| DT_ATTRIBUTE_NUMBER4 | ● | Date attribute number4. | |
| DT_ATTRIBUTE_NUMBER5 | ● | Date attribute number5. | |
| DT_ATTRIBUTE_NUMBER6 | ● | Date attribute number6. | |
| DT_ATTRIBUTE_NUMBER7 | ● | Date attribute number7. | |
| DT_ATTRIBUTE_NUMBER8 | ● | Date attribute number8. | |
| DT_ATTRIBUTE_NUMBER9 | ● | Date attribute number9. | |
| DT_ATTRIBUTE_TIMESTAMP1 | ● | Date attribute timestamp1. | |
| DT_ATTRIBUTE_TIMESTAMP2 | ● | Date attribute timestamp2. | |
| DT_ATTRIBUTE_TIMESTAMP3 | ● | Date attribute timestamp3. | |
| DT_ATTRIBUTE_TIMESTAMP4 | ● | Date attribute timestamp4. | |
| DT_ATTRIBUTE_TIMESTAMP5 | ● | Date attribute timestamp5. | |
| DT_INFORMATION1 | ● | Date information1. | |
| DT_INFORMATION10 | ● | Date information10. | |
| DT_INFORMATION2 | ● | Date information2. | |
| DT_INFORMATION3 | ● | Date information3. | |
| DT_INFORMATION4 | ● | Date information4. | |
| DT_INFORMATION5 | ● | Date information5. | |
| DT_INFORMATION6 | ● | Date information6. | |
| DT_INFORMATION7 | ● | Date information7. | |
| DT_INFORMATION8 | ● | Date information8. | |
| DT_INFORMATION9 | ● | Date information9. | |
| DT_INFORMATION_CATEGORY | ● | Date information category. | |
| DT_INFORMATION_DATE1 | ● | Date information date1. | |
| DT_INFORMATION_DATE10 | ● | Date information date10. | |
| DT_INFORMATION_DATE2 | ● | Date information date2. | |
| DT_INFORMATION_DATE3 | ● | Date information date3. | |
| DT_INFORMATION_DATE4 | ● | Date information date4. | |
| DT_INFORMATION_DATE5 | ● | Date information date5. | |
| DT_INFORMATION_DATE6 | ● | Date information date6. | |
| DT_INFORMATION_DATE7 | ● | Date information date7. | |
| DT_INFORMATION_DATE8 | ● | Date information date8. | |
| DT_INFORMATION_DATE9 | ● | Date information date9. | |
| DT_INFORMATION_NUMBER1 | ● | Date information number1. | |
| DT_INFORMATION_NUMBER10 | ● | Date information number10. | |
| DT_INFORMATION_NUMBER2 | ● | Date information number2. | |
| DT_INFORMATION_NUMBER3 | ● | Date information number3. | |
| DT_INFORMATION_NUMBER4 | ● | Date information number4. | |
| DT_INFORMATION_NUMBER5 | ● | Date information number5. | |
| DT_INFORMATION_NUMBER6 | ● | Date information number6. | |
| DT_INFORMATION_NUMBER7 | ● | Date information number7. | |
| DT_INFORMATION_NUMBER8 | ● | Date information number8. | |
| DT_INFORMATION_NUMBER9 | ● | Date information number9. | |
| DT_INFORMATION_TIMESTAMP1 | ● | Date information timestamp1. | |
| DT_INFORMATION_TIMESTAMP2 | ● | Date information timestamp2. | |
| DT_INFORMATION_TIMESTAMP3 | ● | Date information timestamp3. | |
| DT_INFORMATION_TIMESTAMP4 | ● | Date information timestamp4. | |
| DT_INFORMATION_TIMESTAMP5 | ● | Date information timestamp5. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| HIERARCHY_CODE | ● | Code identifying the hierarchy. | |
| ISSUED_DATE_REQUIRED | ● | Issued date required. | |
| ISSUING_AUTHORITY_REQUIRED | ● | Issuing authority required. | |
| ISSUING_COUNTRY_REQUIRED | ● | Issuing country required. | |
| ISSUING_LOCATION_REQUIRED | ● | Issuing location required. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LEGISLATION_CODE | ● | Code identifying the legislation. | |
| LOCK_CREATE | ● | Lock create. | |
| LOCK_CREATE_ROLE_LIST | ● | Lock create role list. | |
| LOCK_DELETE | ● | Lock delete. | |
| LOCK_DELETE_ROLE_LIST | ● | Lock delete role list. | |
| LOCK_UPDATE | ● | Lock update. | |
| LOCK_UPDATE_ROLE_LIST | ● | Lock update role list. | |
| MIN_ATTACHMENTS_COUNT | ● | Min attachments count. | |
| MODULE_ID | ● | Identifier for the module. | |
| MULTIPLE_OCCURENCES_FLAG | ● | Indicator (Y/N) for the multiple occurences. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PUBLISH_REQUIRED | ● | Publish required. | |
| PURGE_ARCHIVE_CRITERIA_DAYS | ● | Purge archive criteria days. | |
| RESTRICT_CREATE_ATTACH | ● | Restrict create attach. | |
| RESTRICT_DELETE_ATTACH | ● | Restrict delete attach. | |
| RESTRICT_UPDATE_ATTACH | ● | Restrict update attach. | |
| SEED_DATA_SOURCE | ● | Seed data source. | |
| SUB_CATEGORY_CODE | ● | Code identifying the sub category. | |
| SYSTEM_DOCUMENT_TYPE | ● | Type of system document. | |
| TAG_LIST | ● | Tag list. | |
| WARNING_PERIOD | ● | Warning period. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for HR_DOCUMENT_TYPES_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table