[Home] [Help] [Dependency Information]
Object Name: | HR_ADP_ELE_COSTING_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HR_ADP_ELE_COSTING_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns element entry level costing information.
It is intended for use with the ADP Enterprise Payroll interface.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_CODE_EQUIVALENT | VARCHAR2 | (60) | ADP company code | |
GRE_NAME | VARCHAR2 | (240) | Yes | GRE name |
GRE_ID | VARCHAR2 | (60) | GRE ID | |
ORGANIZATION_ID | NUMBER | (15) | Yes | Organization ID for employee's HR organization |
EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business group ID |
PERSON_ID | NUMBER | (10) | Yes | Person ID |
PAY_FREQUENCY | VARCHAR2 | (40) | Payroll frequency | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | Assignment ID |
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | Assignment number | |
ASSIGNMENT_SEQUENCE | NUMBER | Assignment sequence | ||
PRIMARY_FLAG | VARCHAR2 | (30) | Yes | Indicates primary employee assignment. Y/N. |
ELEMENT_ENTRY_ID | NUMBER | (15) | Yes | Element entry ID |
DEDUCTION_NAME | VARCHAR2 | (80) | Yes | Deduction (element) name |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date for element entry | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date for element entry | |
COST_SEGMENT1 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT2 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT3 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT4 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT5 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT6 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT7 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT8 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT9 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT10 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT11 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT12 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT13 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT14 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT15 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT16 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT17 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT18 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT19 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT20 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT21 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT22 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT23 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT24 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT25 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT26 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT27 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT28 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT29 | VARCHAR2 | (60) | Costing key flexfield segment | |
COST_SEGMENT30 | VARCHAR2 | (60) | Costing key flexfield segment | |
GREATEST_LAST_UPDATE_DATE | DATE | Date on which anything significant that is returned by this view was last changed for this employee |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY_CODE_EQUIVALENT
, GRE_NAME
, GRE_ID
, ORGANIZATION_ID
, EMPLOYEE_NUMBER
, BUSINESS_GROUP_ID
, PERSON_ID
, PAY_FREQUENCY
, ASSIGNMENT_ID
, ASSIGNMENT_NUMBER
, ASSIGNMENT_SEQUENCE
, PRIMARY_FLAG
, ELEMENT_ENTRY_ID
, DEDUCTION_NAME
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, COST_SEGMENT1
, COST_SEGMENT2
, COST_SEGMENT3
, COST_SEGMENT4
, COST_SEGMENT5
, COST_SEGMENT6
, COST_SEGMENT7
, COST_SEGMENT8
, COST_SEGMENT9
, COST_SEGMENT10
, COST_SEGMENT11
, COST_SEGMENT12
, COST_SEGMENT13
, COST_SEGMENT14
, COST_SEGMENT15
, COST_SEGMENT16
, COST_SEGMENT17
, COST_SEGMENT18
, COST_SEGMENT19
, COST_SEGMENT20
, COST_SEGMENT21
, COST_SEGMENT22
, COST_SEGMENT23
, COST_SEGMENT24
, COST_SEGMENT25
, COST_SEGMENT26
, COST_SEGMENT27
, COST_SEGMENT28
, COST_SEGMENT29
, COST_SEGMENT30
, GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_ADP_ELE_COSTING_V;
APPS.HR_ADP_ELE_COSTING_V is not referenced by any database object
|
|
|