[Home] [Help] [Dependency Information]
Object Name: | PAY_KR_EMP_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_KR_EMP_DETAILS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EMP_ESTABLISHMENT_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS | |
EMP_ASSIGNMENT_ID | NUMBER | (10) | Yes | System-generated primary key column. |
EMP_PERSON_ID | NUMBER | (10) | Yes | System generated person primary key from PER_PEOPLE_S. |
EMP_FULL_NAME | VARCHAR2 | (300) | Concatenation of last name, title, first name, middle names and the name the person is known by. | |
EMP_NI_NUMBER | VARCHAR2 | (30) | Number by which a person is identified in a given legislation. | |
EMP_DATE_OF_BIRTH | DATE | |||
EMP_SEX | VARCHAR2 | (30) | ||
EMP_START_DATE | DATE | Yes | ||
EMP_END_DATE | DATE | Yes | ||
PERSON_START_DATE | DATE | Yes | ||
PERSON_END_DATE | DATE | Yes | ||
COMPANY_REG_NUM | VARCHAR2 | (150) | ||
COMPANY_NAME | VARCHAR2 | (150) | ||
COUNTRY_OF_BIRTH | VARCHAR2 | (90) | ||
NATIONALITY_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT EMP_ESTABLISHMENT_ID
, EMP_ASSIGNMENT_ID
, EMP_PERSON_ID
, EMP_FULL_NAME
, EMP_NI_NUMBER
, EMP_DATE_OF_BIRTH
, EMP_SEX
, EMP_START_DATE
, EMP_END_DATE
, PERSON_START_DATE
, PERSON_END_DATE
, COMPANY_REG_NUM
, COMPANY_NAME
, COUNTRY_OF_BIRTH
, NATIONALITY_CODE
FROM APPS.PAY_KR_EMP_DETAILS_V;
APPS.PAY_KR_EMP_DETAILS_V is not referenced by any database object
|
|
|