[Home] [Help] [Dependency Information]
Object Name: | HXC_TCD_TMP_RPT# |
---|---|
Object Type: | VIEW |
Owner: | HXC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | (15) | ||
REC_PERIOD_ID | NUMBER | (15) | ||
PERIOD_START_DATE | DATE | |||
PERIOD_END_DATE | DATE | |||
SUPERVISOR_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
SEL_SUPERVISOR_ID | NUMBER | (15) | ||
SEL_TC_STATUS | VARCHAR2 | (20) | ||
RPT_STATUS | VARCHAR2 | (20) | ||
PERSON_TYPE | VARCHAR2 | (30) | ||
PERSON_NAME | VARCHAR2 | (240) | ||
PERSON_NUMBER | VARCHAR2 | (30) | ||
APPROVAL_STATUS | VARCHAR2 | (20) | ||
SUPERVISOR | VARCHAR2 | (240) | ||
ORGANIZATION | VARCHAR2 | (240) | ||
LOCATION | VARCHAR2 | (240) | ||
PAYROLL | VARCHAR2 | (240) | ||
APPLICATION | VARCHAR2 | (240) | ||
TC_START_DATE | DATE | |||
TC_END_DATE | DATE | |||
LAST_MODIFIED_BY | VARCHAR2 | (100) | ||
LAST_MODIFIED_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, REC_PERIOD_ID
, PERIOD_START_DATE
, PERIOD_END_DATE
, SUPERVISOR_ID
, LOCATION_ID
, ORGANIZATION_ID
, SEL_SUPERVISOR_ID
, SEL_TC_STATUS
, RPT_STATUS
, PERSON_TYPE
, PERSON_NAME
, PERSON_NUMBER
, APPROVAL_STATUS
, SUPERVISOR
, ORGANIZATION
, LOCATION
, PAYROLL
, APPLICATION
, TC_START_DATE
, TC_END_DATE
, LAST_MODIFIED_BY
, LAST_MODIFIED_DATE
FROM HXC.HXC_TCD_TMP_RPT#;
|
|
|