[Home] [Help] [Dependency Information]
Object Name: | HXTFV_TIMECARDS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HXT.HXTFV_TIMECARDS |
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 |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | Business Group of person |
PERSON_NAME | VARCHAR2 | (240) | Name of person | |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number | |
PAYROLL_NAME | VARCHAR2 | (80) | Yes | Payroll name |
PERIOD_END_DATE | DATE | Yes | Time period end date | |
PERIOD_START_DATE | DATE | Yes | ||
BATCH_NAME | VARCHAR2 | (30) | Name of the batch | |
APPROVER_NAME | VARCHAR2 | (240) | Name of approver | |
APPROVED_TIMESTAMP | DATE | Time and date timecard was recorded approved | ||
TIMECARD_SOURCE | VARCHAR2 | (4000) | Timecard autogeneration source | |
BATCH_STATUS | VARCHAR2 | (4000) | The status of the timecards batch | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
_DF | CHAR | (27) | ||
APPROVING_PERSON_ID | NUMBER | (10) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
BATCH_ID | NUMBER | (15) | Yes | |
PAYROLL_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
TIMECARD_ID | NUMBER | (15) | Yes | |
TIME_PERIOD_ID | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, EMPLOYEE_NUMBER
, PAYROLL_NAME
, PERIOD_END_DATE
, PERIOD_START_DATE
, BATCH_NAME
, APPROVER_NAME
, APPROVED_TIMESTAMP
, TIMECARD_SOURCE
, BATCH_STATUS
, ATTRIBUTE_CATEGORY
, _DF
, APPROVING_PERSON_ID
, BUSINESS_GROUP_ID
, BATCH_ID
, PAYROLL_ID
, PERSON_ID
, TIMECARD_ID
, TIME_PERIOD_ID
FROM APPS.HXTFV_TIMECARDS;
APPS.HXTFV_TIMECARDS is not referenced by any database object
|
|
|