[Home] [Help] [Dependency Information]
Object Name: | HRI_CS_PRSNDMGR_H_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Creates a structure linking 'PERSON' to HRI_CL_GENDER_X_V (Gender), HRI_CL_GB_
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_START_DATE | DATE | Yes | ||
EFFECTIVE_END_DATE | DATE | Yes | ||
MARITAL_STATUS_CODE | VARCHAR2 | (30) | ||
NATIONALITY_CODE | VARCHAR2 | (30) | ||
GENDER_CODE | VARCHAR2 | (30) | ||
REGISTERED_DISABLED_FLAG | VARCHAR2 | (30) | ||
LEGISLATION_CODE | VARCHAR2 | (30) | ||
GB_ETHINIC_GROUP_CODE | VARCHAR2 | (150) | ||
US_ETHINIC_GROUP_CODE | VARCHAR2 | (150) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
PERSON_TYPE_ID | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, MARITAL_STATUS_CODE
, NATIONALITY_CODE
, GENDER_CODE
, REGISTERED_DISABLED_FLAG
, LEGISLATION_CODE
, GB_ETHINIC_GROUP_CODE
, US_ETHINIC_GROUP_CODE
, BUSINESS_GROUP_ID
, PERSON_ID
, PERSON_TYPE_ID
FROM APPS.HRI_CS_PRSNDMGR_H_V;
|
|
|