[Home] [Help] [Dependency Information]
Object Name: | HXC_TCD_TIMECARDS# |
---|---|
Object Type: | VIEW |
Owner: | HXC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | (10) | ||
REC_PERIOD_ID | NUMBER | (15) | ||
PERIOD_START_DATE | DATE | |||
PERIOD_END_DATE | DATE | |||
PERSON_NUMBER | VARCHAR2 | (30) | ||
PERSON_NAME | VARCHAR2 | (240) | ||
APPROVAL_STATUS | VARCHAR2 | (30) | ||
SUPERVISOR | VARCHAR2 | (240) | ||
ORGANIZATION | VARCHAR2 | (240) | ||
LOCATION | VARCHAR2 | (60) | ||
PERSON_TYPE | VARCHAR2 | (80) | ||
PAYROLL_NAME | VARCHAR2 | (80) | ||
LAST_MODIFIED_BY | VARCHAR2 | (240) | ||
LAST_MODIFIED_DATE | DATE | |||
APPLICATION | VARCHAR2 | (80) | ||
USER_ID | NUMBER | (15) | ||
SUPERVISOR_ID | NUMBER | (10) | ||
NOTIFICATION_ID | NUMBER | |||
TIMECARD_ID | NUMBER | (15) | ||
TIMECARD_OVN | NUMBER | (9) | ||
MEANING | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, REC_PERIOD_ID
, PERIOD_START_DATE
, PERIOD_END_DATE
, PERSON_NUMBER
, PERSON_NAME
, APPROVAL_STATUS
, SUPERVISOR
, ORGANIZATION
, LOCATION
, PERSON_TYPE
, PAYROLL_NAME
, LAST_MODIFIED_BY
, LAST_MODIFIED_DATE
, APPLICATION
, USER_ID
, SUPERVISOR_ID
, NOTIFICATION_ID
, TIMECARD_ID
, TIMECARD_OVN
, MEANING
FROM HXC.HXC_TCD_TIMECARDS#;
|
|
|