eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HRI.HRI_CS_PER_PERSON_CT#

Source

View Text - Preformatted


select PER_PERSON_PK PER_PERSON_PK, PER_PERSON_NAME PER_PERSON_NAME, PER_ORDER_BY PER_ORDER_BY, PER_PERSON_NAME_GBL PER_PERSON_NAME_GBL, PER_PERSON_NAME_LCL PER_PERSON_NAME_LCL, PER_FIRST_NAME PER_FIRST_NAME, PER_LAST_NAME PER_LAST_NAME, PER_LAST_NAME_PREV PER_LAST_NAME_PREV, PER_MIDDLE_NAMES PER_MIDDLE_NAMES, PER_KNOWN_AS PER_KNOWN_AS, PER_HONORS PER_HONORS, PER_TITLE PER_TITLE, PER_SUFFIX PER_SUFFIX, PER_PRE_NAME_ADJUNCT PER_PRE_NAME_ADJUNCT, PER_APL_NUMBER PER_APL_NUMBER, PER_EMP_NUMBER PER_EMP_NUMBER, PER_CWK_NUMBER PER_CWK_NUMBER, PER_APL_FLAG_CRNT_CODE PER_APL_FLAG_CRNT_CODE, PER_EMP_FLAG_CRNT_CODE PER_EMP_FLAG_CRNT_CODE, PER_CWK_FLAG_CRNT_CODE PER_CWK_FLAG_CRNT_CODE, PER_WORKER_CRNT_FLAG_CODE PER_WORKER_CRNT_FLAG_CODE, PER_BUYER_FLAG_CODE PER_BUYER_FLAG_CODE, PER_DATE_OF_BIRTH PER_DATE_OF_BIRTH, PER_PLACE_OF_BIRTH PER_PLACE_OF_BIRTH, PER_COUNTRY_OF_BIRTH PER_COUNTRY_OF_BIRTH, PER_DATE_OF_DEATH PER_DATE_OF_DEATH, PER_WORK_EMAIL PER_WORK_EMAIL, PER_WORK_PHONE PER_WORK_PHONE, PER_WORK_LOCATION PER_WORK_LOCATION, ADT_PPF_PERSON_ID ADT_PPF_PERSON_ID, ADT_PPF_EFFCTV_START_DATE ADT_PPF_EFFCTV_START_DATE, ADT_PPF_EFFCTV_END_DATE ADT_PPF_EFFCTV_END_DATE, PER_MARITAL_STATUS_CRNT PER_MARITAL_STATUS_CRNT, PER_GENDER_CRNT PER_GENDER_CRNT from "HRI"."HRI_CS_PER_PERSON_CT"

View Text - HTML Formatted

SELECT PER_PERSON_PK PER_PERSON_PK
, PER_PERSON_NAME PER_PERSON_NAME
, PER_ORDER_BY PER_ORDER_BY
, PER_PERSON_NAME_GBL PER_PERSON_NAME_GBL
, PER_PERSON_NAME_LCL PER_PERSON_NAME_LCL
, PER_FIRST_NAME PER_FIRST_NAME
, PER_LAST_NAME PER_LAST_NAME
, PER_LAST_NAME_PREV PER_LAST_NAME_PREV
, PER_MIDDLE_NAMES PER_MIDDLE_NAMES
, PER_KNOWN_AS PER_KNOWN_AS
, PER_HONORS PER_HONORS
, PER_TITLE PER_TITLE
, PER_SUFFIX PER_SUFFIX
, PER_PRE_NAME_ADJUNCT PER_PRE_NAME_ADJUNCT
, PER_APL_NUMBER PER_APL_NUMBER
, PER_EMP_NUMBER PER_EMP_NUMBER
, PER_CWK_NUMBER PER_CWK_NUMBER
, PER_APL_FLAG_CRNT_CODE PER_APL_FLAG_CRNT_CODE
, PER_EMP_FLAG_CRNT_CODE PER_EMP_FLAG_CRNT_CODE
, PER_CWK_FLAG_CRNT_CODE PER_CWK_FLAG_CRNT_CODE
, PER_WORKER_CRNT_FLAG_CODE PER_WORKER_CRNT_FLAG_CODE
, PER_BUYER_FLAG_CODE PER_BUYER_FLAG_CODE
, PER_DATE_OF_BIRTH PER_DATE_OF_BIRTH
, PER_PLACE_OF_BIRTH PER_PLACE_OF_BIRTH
, PER_COUNTRY_OF_BIRTH PER_COUNTRY_OF_BIRTH
, PER_DATE_OF_DEATH PER_DATE_OF_DEATH
, PER_WORK_EMAIL PER_WORK_EMAIL
, PER_WORK_PHONE PER_WORK_PHONE
, PER_WORK_LOCATION PER_WORK_LOCATION
, ADT_PPF_PERSON_ID ADT_PPF_PERSON_ID
, ADT_PPF_EFFCTV_START_DATE ADT_PPF_EFFCTV_START_DATE
, ADT_PPF_EFFCTV_END_DATE ADT_PPF_EFFCTV_END_DATE
, PER_MARITAL_STATUS_CRNT PER_MARITAL_STATUS_CRNT
, PER_GENDER_CRNT PER_GENDER_CRNT
FROM "HRI"."HRI_CS_PER_PERSON_CT"