[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_PAY_INTERFACE_ASSIGNMENTS_V is not referenced by any database object
|
|
|