[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HR_PAY_INTERFACE_ASSIGNMENTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| FULL_NAME | VARCHAR2 | (240) | ||
| ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
| PRIMARY_ASSIGNMENT_FLAG | VARCHAR2 | (30) | Yes | |
| SUPERVISOR_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| JOB_NAME | VARCHAR2 | (700) | ||
| GRADE_NAME | VARCHAR2 | (240) | ||
| PAY_BASIS_NAME | VARCHAR2 | (30) | ||
| LOCATION_CODE | VARCHAR2 | (60) | ||
| NORMAL_HOURS | NUMBER | (22) | ||
| PAYROLL_NAME | VARCHAR2 | (80) | Yes | |
| PAY_FREQUENCY | NUMBER | (15) | Yes | |
| PAYROLL_STATUS | VARCHAR2 | (1) | ||
| BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
| ASG_EFFECTIVE_START_DATE | DATE | Yes | ||
| ASG_EFFECTIVE_END_DATE | DATE | Yes | ||
| ASG_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE21 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE22 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE23 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE24 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE25 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE26 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE27 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE28 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE29 | VARCHAR2 | (150) | ||
| ASG_ATTRIBUTE30 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ORG_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| JOB_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| JDEF_SEGMENT1 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT2 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT3 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT4 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT5 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT6 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT7 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT8 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT9 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT10 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT11 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT12 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT13 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT14 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT15 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT16 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT17 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT18 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT19 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT20 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT21 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT22 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT23 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT24 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT25 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT26 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT27 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT28 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT29 | VARCHAR2 | (60) | ||
| JDEF_SEGMENT30 | VARCHAR2 | (60) | ||
| PPG_SEGMENT1 | VARCHAR2 | (60) | ||
| PPG_SEGMENT2 | VARCHAR2 | (60) | ||
| PPG_SEGMENT3 | VARCHAR2 | (60) | ||
| PPG_SEGMENT4 | VARCHAR2 | (60) | ||
| PPG_SEGMENT5 | VARCHAR2 | (60) | ||
| PPG_SEGMENT6 | VARCHAR2 | (60) | ||
| PPG_SEGMENT7 | VARCHAR2 | (60) | ||
| PPG_SEGMENT8 | VARCHAR2 | (60) | ||
| PPG_SEGMENT9 | VARCHAR2 | (60) | ||
| PPG_SEGMENT10 | VARCHAR2 | (60) | ||
| PPG_SEGMENT11 | VARCHAR2 | (60) | ||
| PPG_SEGMENT12 | VARCHAR2 | (60) | ||
| PPG_SEGMENT13 | VARCHAR2 | (60) | ||
| PPG_SEGMENT14 | VARCHAR2 | (60) | ||
| PPG_SEGMENT15 | VARCHAR2 | (60) | ||
| PPG_SEGMENT16 | VARCHAR2 | (60) | ||
| PPG_SEGMENT17 | VARCHAR2 | (60) | ||
| PPG_SEGMENT18 | VARCHAR2 | (60) | ||
| PPG_SEGMENT19 | VARCHAR2 | (60) | ||
| PPG_SEGMENT20 | VARCHAR2 | (60) | ||
| PPG_SEGMENT21 | VARCHAR2 | (60) | ||
| PPG_SEGMENT22 | VARCHAR2 | (60) | ||
| PPG_SEGMENT23 | VARCHAR2 | (60) | ||
| PPG_SEGMENT24 | VARCHAR2 | (60) | ||
| PPG_SEGMENT25 | VARCHAR2 | (60) | ||
| PPG_SEGMENT26 | VARCHAR2 | (60) | ||
| PPG_SEGMENT27 | VARCHAR2 | (60) | ||
| PPG_SEGMENT28 | VARCHAR2 | (60) | ||
| PPG_SEGMENT29 | VARCHAR2 | (60) | ||
| PPG_SEGMENT30 | VARCHAR2 | (60) | ||
| PERSON_ID | NUMBER | (10) | Yes | |
| SUPERVISOR_PERSON_ID | NUMBER | (10) | ||
| ASSIGNMENT_ID | NUMBER | (10) | Yes | |
| PAY_BASIS_ID | NUMBER | (9) | ||
| JOB_ID | NUMBER | (15) | Yes | |
| GRADE_ID | NUMBER | (15) | ||
| LOCATION_ID | NUMBER | (15) | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| ORGANIZATION_ID | NUMBER | (15) | Yes | |
| PAYROLL_ID | NUMBER | (9) | Yes | |
| GREATEST_LAST_UPDATE_DATE | DATE | |||
| PER_LAST_UPDATE_DATE | DATE | |||
| ASG_LAST_UPDATE_DATE | DATE | |||
| HL_LAST_UPDATE_DATE | DATE | |||
| PPG_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_NUMBER
, FULL_NAME
, ASSIGNMENT_NUMBER
, PRIMARY_ASSIGNMENT_FLAG
, SUPERVISOR_EMPLOYEE_NUMBER
, JOB_NAME
, GRADE_NAME
, PAY_BASIS_NAME
, LOCATION_CODE
, NORMAL_HOURS
, PAYROLL_NAME
, PAY_FREQUENCY
, PAYROLL_STATUS
, BUSINESS_GROUP_NAME
, ORGANIZATION_NAME
, ASG_EFFECTIVE_START_DATE
, ASG_EFFECTIVE_END_DATE
, ASG_ATTRIBUTE1
, ASG_ATTRIBUTE2
, ASG_ATTRIBUTE3
, ASG_ATTRIBUTE4
, ASG_ATTRIBUTE5
, ASG_ATTRIBUTE6
, ASG_ATTRIBUTE7
, ASG_ATTRIBUTE8
, ASG_ATTRIBUTE9
, ASG_ATTRIBUTE10
, ASG_ATTRIBUTE11
, ASG_ATTRIBUTE12
, ASG_ATTRIBUTE13
, ASG_ATTRIBUTE14
, ASG_ATTRIBUTE15
, ASG_ATTRIBUTE16
, ASG_ATTRIBUTE17
, ASG_ATTRIBUTE18
, ASG_ATTRIBUTE19
, ASG_ATTRIBUTE20
, ASG_ATTRIBUTE21
, ASG_ATTRIBUTE22
, ASG_ATTRIBUTE23
, ASG_ATTRIBUTE24
, ASG_ATTRIBUTE25
, ASG_ATTRIBUTE26
, ASG_ATTRIBUTE27
, ASG_ATTRIBUTE28
, ASG_ATTRIBUTE29
, ASG_ATTRIBUTE30
, ORG_ATTRIBUTE1
, ORG_ATTRIBUTE2
, ORG_ATTRIBUTE3
, ORG_ATTRIBUTE4
, ORG_ATTRIBUTE5
, ORG_ATTRIBUTE6
, ORG_ATTRIBUTE7
, ORG_ATTRIBUTE8
, ORG_ATTRIBUTE9
, ORG_ATTRIBUTE10
, ORG_ATTRIBUTE11
, ORG_ATTRIBUTE12
, ORG_ATTRIBUTE13
, ORG_ATTRIBUTE14
, ORG_ATTRIBUTE15
, ORG_ATTRIBUTE16
, ORG_ATTRIBUTE17
, ORG_ATTRIBUTE18
, ORG_ATTRIBUTE19
, ORG_ATTRIBUTE20
, JOB_ATTRIBUTE1
, JOB_ATTRIBUTE2
, JOB_ATTRIBUTE3
, JOB_ATTRIBUTE4
, JOB_ATTRIBUTE5
, JOB_ATTRIBUTE6
, JOB_ATTRIBUTE7
, JOB_ATTRIBUTE8
, JOB_ATTRIBUTE9
, JOB_ATTRIBUTE10
, JOB_ATTRIBUTE11
, JOB_ATTRIBUTE12
, JOB_ATTRIBUTE13
, JOB_ATTRIBUTE14
, JOB_ATTRIBUTE15
, JOB_ATTRIBUTE16
, JOB_ATTRIBUTE17
, JOB_ATTRIBUTE18
, JOB_ATTRIBUTE19
, JOB_ATTRIBUTE20
, JDEF_SEGMENT1
, JDEF_SEGMENT2
, JDEF_SEGMENT3
, JDEF_SEGMENT4
, JDEF_SEGMENT5
, JDEF_SEGMENT6
, JDEF_SEGMENT7
, JDEF_SEGMENT8
, JDEF_SEGMENT9
, JDEF_SEGMENT10
, JDEF_SEGMENT11
, JDEF_SEGMENT12
, JDEF_SEGMENT13
, JDEF_SEGMENT14
, JDEF_SEGMENT15
, JDEF_SEGMENT16
, JDEF_SEGMENT17
, JDEF_SEGMENT18
, JDEF_SEGMENT19
, JDEF_SEGMENT20
, JDEF_SEGMENT21
, JDEF_SEGMENT22
, JDEF_SEGMENT23
, JDEF_SEGMENT24
, JDEF_SEGMENT25
, JDEF_SEGMENT26
, JDEF_SEGMENT27
, JDEF_SEGMENT28
, JDEF_SEGMENT29
, JDEF_SEGMENT30
, PPG_SEGMENT1
, PPG_SEGMENT2
, PPG_SEGMENT3
, PPG_SEGMENT4
, PPG_SEGMENT5
, PPG_SEGMENT6
, PPG_SEGMENT7
, PPG_SEGMENT8
, PPG_SEGMENT9
, PPG_SEGMENT10
, PPG_SEGMENT11
, PPG_SEGMENT12
, PPG_SEGMENT13
, PPG_SEGMENT14
, PPG_SEGMENT15
, PPG_SEGMENT16
, PPG_SEGMENT17
, PPG_SEGMENT18
, PPG_SEGMENT19
, PPG_SEGMENT20
, PPG_SEGMENT21
, PPG_SEGMENT22
, PPG_SEGMENT23
, PPG_SEGMENT24
, PPG_SEGMENT25
, PPG_SEGMENT26
, PPG_SEGMENT27
, PPG_SEGMENT28
, PPG_SEGMENT29
, PPG_SEGMENT30
, PERSON_ID
, SUPERVISOR_PERSON_ID
, ASSIGNMENT_ID
, PAY_BASIS_ID
, JOB_ID
, GRADE_ID
, LOCATION_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, PAYROLL_ID
, GREATEST_LAST_UPDATE_DATE
, PER_LAST_UPDATE_DATE
, ASG_LAST_UPDATE_DATE
, HL_LAST_UPDATE_DATE
, PPG_LAST_UPDATE_DATE
FROM APPS.HR_PAY_INTERFACE_ASSIGNMENTS_V;
APPS
HR_ALL_ORGANIZATION_UNITS
HR_GENERAL
- show dependent code
HR_LOCATIONS
HR_PAY_INTERFACE_PKG
- show dependent code
PAY_ALL_PAYROLLS_F
PAY_PEOPLE_GROUPS
PER_ALL_ASSIGNMENTS_F
PER_ALL_PEOPLE_F
PER_ASSIGNMENT_STATUS_TYPES
PER_ASS_STATUS_TYPE_AMENDS
PER_GRADES
PER_JOBS
PER_JOB_DEFINITIONS
PER_PAY_BASES
PER_TIME_PERIOD_TYPES
APPS.HR_PAY_INTERFACE_ASSIGNMENTS_V is not referenced by any database object
|
|
|
|