[Home] [Help] [Dependency Information]
Object Name: | HRI_CS_PRSNTYP_CT |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
This table stores the data related to the PersonTypes present in the system which will be used in HRI Discoverer reports.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_CS_PRSNTYP_CT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_TYPE_ID
EMPLOYMENT_CATEGORY_CODE PRIMARY_FLAG_CODE ASSIGNMENT_TYPE_CODE |
HRI_CS_PRSNTYP_CT_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRSNTYP_SK_PK |
HRI_CS_PRSNTYP_CT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
WKTH_LVL2_SK_FK
WKTH_LVL1_SK_FK WKTH_WKTYP_SK_FK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRSNTYP_SK_PK | NUMBER | PRSNTYP_SK_PK | ||
WKTH_WKTYP_SK_FK | VARCHAR2 | (240) | WKTH_WKTYP_SK_FK | |
WKTH_LVL1_SK_FK | VARCHAR2 | (240) | WKTH_LVL1_SK_FK | |
WKTH_LVL2_SK_FK | VARCHAR2 | (240) | WKTH_LVL2_SK_FK | |
WKTH_WKTYP_CODE | VARCHAR2 | (30) | WKTH_WKTYP_CODE | |
WKTH_LVL1_CODE | VARCHAR2 | (30) | WKTH_LVL1_CODE | |
WKTH_LVL2_CODE | VARCHAR2 | (30) | WKTH_LVL2_CODE | |
PERSON_TYPE_ID | NUMBER | PERSON_TYPE_ID | ||
PRIMARY_FLAG_CODE | VARCHAR2 | (30) | PRIMARY_FLAG_CODE | |
ASSIGNMENT_TYPE_CODE | VARCHAR2 | (30) | ASSIGNMENT_TYPE_CODE | |
EMPLOYMENT_CATEGORY_CODE | VARCHAR2 | (30) | EMPLOYMENT_CATEGORY_CODE | |
INCLUDE_FLAG_CODE | VARCHAR2 | (30) | INCLUDE_FLAG_CODE | |
LAST_UPDATE_DATE | DATE | LAST_UPDATE_DATE | ||
LAST_UPDATE_LOGIN | NUMBER | LAST_UPDATE_LOGIN | ||
LAST_UPDATED_BY | NUMBER | LAST_UPDATED_BY | ||
CREATED_BY | NUMBER | CREATED_BY | ||
CREATION_DATE | DATE | CREATION_DATE |
Cut, paste (and edit) the following text to query this object:
SELECT PRSNTYP_SK_PK
, WKTH_WKTYP_SK_FK
, WKTH_LVL1_SK_FK
, WKTH_LVL2_SK_FK
, WKTH_WKTYP_CODE
, WKTH_LVL1_CODE
, WKTH_LVL2_CODE
, PERSON_TYPE_ID
, PRIMARY_FLAG_CODE
, ASSIGNMENT_TYPE_CODE
, EMPLOYMENT_CATEGORY_CODE
, INCLUDE_FLAG_CODE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
FROM HRI.HRI_CS_PRSNTYP_CT;
HRI.HRI_CS_PRSNTYP_CT does not reference any database object
HRI.HRI_CS_PRSNTYP_CT is referenced by following:
|
|
|