[Home] [Help] [Dependency Information]
Object Name: | HRI_CS_PER_PERSON_CT |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
This table stores the data related to each person which is used by HRI Discoverer reports.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_CS_PER_PERSON_CT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PER_PERSON_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PER_PERSON_PK | NUMBER | (10) | PER_PERSON_PK | |
PER_PERSON_NAME | VARCHAR2 | (240) | PER_PERSON_NAME | |
PER_ORDER_BY | VARCHAR2 | (240) | PER_ORDER_BY | |
PER_PERSON_NAME_GBL | VARCHAR2 | (240) | PER_PERSON_NAME_GBL | |
PER_PERSON_NAME_LCL | VARCHAR2 | (240) | PER_PERSON_NAME_LCL | |
PER_FIRST_NAME | VARCHAR2 | (150) | PER_FIRST_NAME | |
PER_LAST_NAME | VARCHAR2 | (150) | PER_LAST_NAME | |
PER_LAST_NAME_PREV | VARCHAR2 | (150) | PER_LAST_NAME_PREV | |
PER_MIDDLE_NAMES | VARCHAR2 | (150) | PER_MIDDLE_NAMES | |
PER_KNOWN_AS | VARCHAR2 | (80) | PER_KNOWN_AS | |
PER_HONORS | VARCHAR2 | (45) | PER_HONORS | |
PER_TITLE | VARCHAR2 | (30) | PER_TITLE | |
PER_SUFFIX | VARCHAR2 | (30) | PER_SUFFIX | |
PER_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | PER_PRE_NAME_ADJUNCT | |
PER_APL_NUMBER | VARCHAR2 | (30) | PER_APL_NUMBER | |
PER_EMP_NUMBER | VARCHAR2 | (30) | PER_EMP_NUMBER | |
PER_CWK_NUMBER | VARCHAR2 | (30) | PER_CWK_NUMBER | |
PER_APL_FLAG_CRNT_CODE | VARCHAR2 | (30) | PER_APL_FLAG_CRNT_CODE | |
PER_EMP_FLAG_CRNT_CODE | VARCHAR2 | (30) | PER_EMP_FLAG_CRNT_CODE | |
PER_CWK_FLAG_CRNT_CODE | VARCHAR2 | (30) | PER_CWK_FLAG_CRNT_CODE | |
PER_WORKER_CRNT_FLAG_CODE | VARCHAR2 | (30) | PER_WORKER_CRNT_FLAG_CODE | |
PER_BUYER_FLAG_CODE | VARCHAR2 | (30) | PER_BUYER_FLAG_CODE | |
PER_DATE_OF_BIRTH | DATE | PER_DATE_OF_BIRTH | ||
PER_PLACE_OF_BIRTH | VARCHAR2 | (90) | PER_PLACE_OF_BIRTH | |
PER_COUNTRY_OF_BIRTH | VARCHAR2 | (90) | PER_COUNTRY_OF_BIRTH | |
PER_DATE_OF_DEATH | DATE | PER_DATE_OF_DEATH | ||
PER_WORK_EMAIL | VARCHAR2 | (240) | PER_WORK_EMAIL | |
PER_WORK_PHONE | VARCHAR2 | (100) | PER_WORK_PHONE | |
PER_WORK_LOCATION | VARCHAR2 | (100) | PER_WORK_LOCATION | |
ADT_PPF_PERSON_ID | NUMBER | (10) | ADT_PPF_PERSON_ID | |
ADT_PPF_EFFCTV_START_DATE | DATE | ADT_PPF_EFFCTV_START_DATE | ||
ADT_PPF_EFFCTV_END_DATE | DATE | ADT_PPF_EFFCTV_END_DATE | ||
PER_MARITAL_STATUS_CRNT | VARCHAR2 | (30) | PER_MARITAL_STATUS_CRNT | |
PER_GENDER_CRNT | VARCHAR2 | (30) | PER_GENDER_CRNT |
Cut, paste (and edit) the following text to query this object:
SELECT PER_PERSON_PK
, PER_PERSON_NAME
, PER_ORDER_BY
, PER_PERSON_NAME_GBL
, PER_PERSON_NAME_LCL
, PER_FIRST_NAME
, PER_LAST_NAME
, PER_LAST_NAME_PREV
, PER_MIDDLE_NAMES
, PER_KNOWN_AS
, PER_HONORS
, PER_TITLE
, PER_SUFFIX
, PER_PRE_NAME_ADJUNCT
, PER_APL_NUMBER
, PER_EMP_NUMBER
, PER_CWK_NUMBER
, PER_APL_FLAG_CRNT_CODE
, PER_EMP_FLAG_CRNT_CODE
, PER_CWK_FLAG_CRNT_CODE
, PER_WORKER_CRNT_FLAG_CODE
, PER_BUYER_FLAG_CODE
, PER_DATE_OF_BIRTH
, PER_PLACE_OF_BIRTH
, PER_COUNTRY_OF_BIRTH
, PER_DATE_OF_DEATH
, PER_WORK_EMAIL
, PER_WORK_PHONE
, PER_WORK_LOCATION
, ADT_PPF_PERSON_ID
, ADT_PPF_EFFCTV_START_DATE
, ADT_PPF_EFFCTV_END_DATE
, PER_MARITAL_STATUS_CRNT
, PER_GENDER_CRNT
FROM HRI.HRI_CS_PER_PERSON_CT;
HRI.HRI_CS_PER_PERSON_CT does not reference any database object
HRI.HRI_CS_PER_PERSON_CT is referenced by following:
|
|
|