[Home] [Help] [Dependency Information]
Object Name: | HRI_CS_PER_PERSON_CT# |
---|---|
Object Type: | VIEW |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PER_PERSON_PK | NUMBER | (10) | ||
PER_PERSON_NAME | VARCHAR2 | (240) | ||
PER_ORDER_BY | VARCHAR2 | (240) | ||
PER_PERSON_NAME_GBL | VARCHAR2 | (240) | ||
PER_PERSON_NAME_LCL | VARCHAR2 | (240) | ||
PER_FIRST_NAME | VARCHAR2 | (150) | ||
PER_LAST_NAME | VARCHAR2 | (150) | ||
PER_LAST_NAME_PREV | VARCHAR2 | (150) | ||
PER_MIDDLE_NAMES | VARCHAR2 | (150) | ||
PER_KNOWN_AS | VARCHAR2 | (80) | ||
PER_HONORS | VARCHAR2 | (45) | ||
PER_TITLE | VARCHAR2 | (30) | ||
PER_SUFFIX | VARCHAR2 | (30) | ||
PER_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | ||
PER_APL_NUMBER | VARCHAR2 | (30) | ||
PER_EMP_NUMBER | VARCHAR2 | (30) | ||
PER_CWK_NUMBER | VARCHAR2 | (30) | ||
PER_APL_FLAG_CRNT_CODE | VARCHAR2 | (30) | ||
PER_EMP_FLAG_CRNT_CODE | VARCHAR2 | (30) | ||
PER_CWK_FLAG_CRNT_CODE | VARCHAR2 | (30) | ||
PER_WORKER_CRNT_FLAG_CODE | VARCHAR2 | (30) | ||
PER_BUYER_FLAG_CODE | VARCHAR2 | (30) | ||
PER_DATE_OF_BIRTH | DATE | |||
PER_PLACE_OF_BIRTH | VARCHAR2 | (90) | ||
PER_COUNTRY_OF_BIRTH | VARCHAR2 | (90) | ||
PER_DATE_OF_DEATH | DATE | |||
PER_WORK_EMAIL | VARCHAR2 | (240) | ||
PER_WORK_PHONE | VARCHAR2 | (100) | ||
PER_WORK_LOCATION | VARCHAR2 | (100) | ||
ADT_PPF_PERSON_ID | NUMBER | (10) | ||
ADT_PPF_EFFCTV_START_DATE | DATE | |||
ADT_PPF_EFFCTV_END_DATE | DATE | |||
PER_MARITAL_STATUS_CRNT | VARCHAR2 | (30) | ||
PER_GENDER_CRNT | VARCHAR2 | (30) |
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#;
|
|
|