[Home] [Help] [Dependency Information]
Object Name: | PQH_COPY_ENTITY_ATTRIBS_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
NAME | VARCHAR2 | (2000) | ||
JOB | VARCHAR2 | (255) | ||
ORGANIZATION | VARCHAR2 | (2000) | ||
BUSINESS_GROUP | VARCHAR2 | (255) | ||
HIRING_STATUS | VARCHAR2 | (255) | ||
LOCATION | VARCHAR2 | (255) | ||
START_DATE | DATE | |||
HEAD_COUNT | NUMBER | |||
DATE_END | DATE | |||
STATUS | VARCHAR2 | (255) | ||
SUCCESSOR_POSITION | VARCHAR2 | (255) | ||
EFFECTIVE_DATE | DATE | |||
SUPERVISOR | VARCHAR2 | (255) | ||
SUPERVISOR_POSITION | VARCHAR2 | (255) | ||
EARLIEST_HIRE_DATE | DATE | |||
FILL_BY_DATE | DATE | |||
FTE | NUMBER | |||
GRADE | VARCHAR2 | (2000) | ||
POSITION_STATUS | VARCHAR2 | (255) | ||
PERMANENT_FLAG | VARCHAR2 | (255) | ||
PERMIT_RECRUITING | VARCHAR2 | (2000) | ||
POSITION_TYPE | VARCHAR2 | (255) | ||
WORKING_HRS | NUMBER | |||
FREQUENCY | VARCHAR2 | (255) | ||
BARGAINING_UNIT | VARCHAR2 | (2000) | ||
HIRING_PROPOSED_END_DATE | DATE | |||
POSITION | VARCHAR2 | (255) | ||
GRADE_LADDER | VARCHAR2 | (2000) | ||
PAYROLL | VARCHAR2 | (255) | ||
ASSIGNMENT_STATUS | VARCHAR2 | (2000) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (2000) | ||
SUPERVISOR_ASSIGNMENT | VARCHAR2 | (2000) | ||
MANAGER | VARCHAR2 | (255) | ||
SALARY_BASIS | VARCHAR2 | (255) | ||
WORKING_HOURS | NUMBER | |||
WORKING_FREQUENCY | VARCHAR2 | (2000) | ||
START_TIME | VARCHAR2 | (2000) | ||
FINISH_TIME | VARCHAR2 | (255) | ||
HOURLY_SALARIED | VARCHAR2 | (2000) | ||
UNION_MEMBER | VARCHAR2 | (255) | ||
SUPPLIER_NAME | VARCHAR2 | (2000) | ||
SUPPLIER_SITE | VARCHAR2 | (2000) | ||
SALARY_REVIEW_PERIOD | NUMBER | |||
SALARY_REVIEW_FREQUENCY | VARCHAR2 | (255) | ||
PERFORMANCE_REVIEW_PERIOD | NUMBER | |||
PERFORMANCE_REVIEW_FREQUENCY | VARCHAR2 | (2000) | ||
CHANGE_REASON | VARCHAR2 | (2000) | ||
PROJECTED_END_DATE | DATE | |||
ORGANIZATION_HIERARCHY | VARCHAR2 | (255) | ||
ORG_HIERARCHY_NODE | VARCHAR2 | (255) | ||
JOB_LIKE | VARCHAR2 | (255) | ||
POSITION_LIKE | VARCHAR2 | (255) | ||
POSITION_HIERARCHY | VARCHAR2 | (255) | ||
POSITION_HIERARCHY_NODE | VARCHAR2 | (255) | ||
GRADE_LIKE | VARCHAR2 | (255) | ||
GRADE_LADDER_LIKE | VARCHAR2 | (2000) | ||
PAYROLL_NAME | VARCHAR2 | (255) | ||
PRIMARY_ASSIGNMENT | VARCHAR2 | (255) | ||
ASSIGNMENT_CATEGORY | VARCHAR2 | (2000) | ||
MANAGER_FLAG | VARCHAR2 | (255) | ||
USER_PERSON_TYPE | VARCHAR2 | (255) | ||
HIRE_DATE | DATE | |||
INTERNAL_ADDRESS | VARCHAR2 | (255) | ||
COLLECTIVE_AGREEMENT | VARCHAR2 | (2000) | ||
ESTABLISHMENT | VARCHAR2 | (255) | ||
HIERARCHY_NODE | VARCHAR2 | (255) | ||
POSITION_NODE | VARCHAR2 | (255) | ||
SYSTEM_PERSON_TYPE | VARCHAR2 | (255) | ||
LATEST_HIRE_DATE | DATE | |||
ESTABLISHMENT_ID | VARCHAR2 | (2000) | ||
HOURLY_SALARIED_CODE | VARCHAR2 | (2000) | ||
INTERNAL_ADDRESS_LINE | VARCHAR2 | (2000) | ||
RECRUITMENT_ACTIVITY | VARCHAR2 | (255) | ||
VACANCY | VARCHAR2 | (255) | ||
PROJECTED_HIRE_DATE | DATE | |||
RECRUITER | VARCHAR2 | (255) | ||
REFERRED_BY | VARCHAR2 | (255) | ||
RECRUITMENT_SOURCE_TYPE | VARCHAR2 | (255) | ||
SOURCE_ORGANIZATION | VARCHAR2 | (255) | ||
BARGAIN_UNIT | VARCHAR2 | (255) | ||
HEADCOUNT | NUMBER | |||
CONCATENATED_SEGMENTS | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, NAME
, JOB
, ORGANIZATION
, BUSINESS_GROUP
, HIRING_STATUS
, LOCATION
, START_DATE
, HEAD_COUNT
, DATE_END
, STATUS
, SUCCESSOR_POSITION
, EFFECTIVE_DATE
, SUPERVISOR
, SUPERVISOR_POSITION
, EARLIEST_HIRE_DATE
, FILL_BY_DATE
, FTE
, GRADE
, POSITION_STATUS
, PERMANENT_FLAG
, PERMIT_RECRUITING
, POSITION_TYPE
, WORKING_HRS
, FREQUENCY
, BARGAINING_UNIT
, HIRING_PROPOSED_END_DATE
, POSITION
, GRADE_LADDER
, PAYROLL
, ASSIGNMENT_STATUS
, EMPLOYMENT_CATEGORY
, SUPERVISOR_ASSIGNMENT
, MANAGER
, SALARY_BASIS
, WORKING_HOURS
, WORKING_FREQUENCY
, START_TIME
, FINISH_TIME
, HOURLY_SALARIED
, UNION_MEMBER
, SUPPLIER_NAME
, SUPPLIER_SITE
, SALARY_REVIEW_PERIOD
, SALARY_REVIEW_FREQUENCY
, PERFORMANCE_REVIEW_PERIOD
, PERFORMANCE_REVIEW_FREQUENCY
, CHANGE_REASON
, PROJECTED_END_DATE
, ORGANIZATION_HIERARCHY
, ORG_HIERARCHY_NODE
, JOB_LIKE
, POSITION_LIKE
, POSITION_HIERARCHY
, POSITION_HIERARCHY_NODE
, GRADE_LIKE
, GRADE_LADDER_LIKE
, PAYROLL_NAME
, PRIMARY_ASSIGNMENT
, ASSIGNMENT_CATEGORY
, MANAGER_FLAG
, USER_PERSON_TYPE
, HIRE_DATE
, INTERNAL_ADDRESS
, COLLECTIVE_AGREEMENT
, ESTABLISHMENT
, HIERARCHY_NODE
, POSITION_NODE
, SYSTEM_PERSON_TYPE
, LATEST_HIRE_DATE
, ESTABLISHMENT_ID
, HOURLY_SALARIED_CODE
, INTERNAL_ADDRESS_LINE
, RECRUITMENT_ACTIVITY
, VACANCY
, PROJECTED_HIRE_DATE
, RECRUITER
, REFERRED_BY
, RECRUITMENT_SOURCE_TYPE
, SOURCE_ORGANIZATION
, BARGAIN_UNIT
, HEADCOUNT
, CONCATENATED_SEGMENTS
FROM APPS.PQH_COPY_ENTITY_ATTRIBS_DFV;
|
|
|