VIEW: HR.HR_H2PI_ASSIGNMENTS#

Source

View Text - Preformatted

select LAST_UPD_DATE LAST_UPD_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CLIENT_ID CLIENT_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PERSON_ID PERSON_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, PRIMARY_FLAG PRIMARY_FLAG, FREQUENCY FREQUENCY, NORMAL_HOURS NORMAL_HOURS, TITLE TITLE, PAY_BASIS_ID PAY_BASIS_ID, LOCATION_ID LOCATION_ID, ORGANIZATION_ID ORGANIZATION_ID, PAYROLL_ID PAYROLL_ID, HOURLY_SALARIED_CODE HOURLY_SALARIED_CODE, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30, TIME_NORMAL_FINISH TIME_NORMAL_FINISH, TIME_NORMAL_START TIME_NORMAL_START, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE_CATEGORY, ASS_ATTRIBUTE1 ASS_ATTRIBUTE1, ASS_ATTRIBUTE2 ASS_ATTRIBUTE2, ASS_ATTRIBUTE3 ASS_ATTRIBUTE3, ASS_ATTRIBUTE4 ASS_ATTRIBUTE4, ASS_ATTRIBUTE5 ASS_ATTRIBUTE5, ASS_ATTRIBUTE6 ASS_ATTRIBUTE6, ASS_ATTRIBUTE7 ASS_ATTRIBUTE7, ASS_ATTRIBUTE8 ASS_ATTRIBUTE8, ASS_ATTRIBUTE9 ASS_ATTRIBUTE9, ASS_ATTRIBUTE10 ASS_ATTRIBUTE10, ASS_ATTRIBUTE11 ASS_ATTRIBUTE11, ASS_ATTRIBUTE12 ASS_ATTRIBUTE12, ASS_ATTRIBUTE13 ASS_ATTRIBUTE13, ASS_ATTRIBUTE14 ASS_ATTRIBUTE14, ASS_ATTRIBUTE15 ASS_ATTRIBUTE15, ASS_ATTRIBUTE16 ASS_ATTRIBUTE16, ASS_ATTRIBUTE17 ASS_ATTRIBUTE17, ASS_ATTRIBUTE18 ASS_ATTRIBUTE18, ASS_ATTRIBUTE19 ASS_ATTRIBUTE19, ASS_ATTRIBUTE20 ASS_ATTRIBUTE20, ASS_ATTRIBUTE21 ASS_ATTRIBUTE21, ASS_ATTRIBUTE22 ASS_ATTRIBUTE22, ASS_ATTRIBUTE23 ASS_ATTRIBUTE23, ASS_ATTRIBUTE24 ASS_ATTRIBUTE24, ASS_ATTRIBUTE25 ASS_ATTRIBUTE25, ASS_ATTRIBUTE26 ASS_ATTRIBUTE26, ASS_ATTRIBUTE27 ASS_ATTRIBUTE27, ASS_ATTRIBUTE28 ASS_ATTRIBUTE28, ASS_ATTRIBUTE29 ASS_ATTRIBUTE29, ASS_ATTRIBUTE30 ASS_ATTRIBUTE30, STATUS STATUS, PPG_SEGMENT1 PPG_SEGMENT1, PPG_SEGMENT2 PPG_SEGMENT2, PPG_SEGMENT3 PPG_SEGMENT3, PPG_SEGMENT4 PPG_SEGMENT4, PPG_SEGMENT5 PPG_SEGMENT5, PPG_SEGMENT6 PPG_SEGMENT6, PPG_SEGMENT7 PPG_SEGMENT7, PPG_SEGMENT8 PPG_SEGMENT8, PPG_SEGMENT9 PPG_SEGMENT9, PPG_SEGMENT10 PPG_SEGMENT10, PPG_SEGMENT11 PPG_SEGMENT11, PPG_SEGMENT12 PPG_SEGMENT12, PPG_SEGMENT13 PPG_SEGMENT13, PPG_SEGMENT14 PPG_SEGMENT14, PPG_SEGMENT15 PPG_SEGMENT15, PPG_SEGMENT16 PPG_SEGMENT16, PPG_SEGMENT17 PPG_SEGMENT17, PPG_SEGMENT18 PPG_SEGMENT18, PPG_SEGMENT19 PPG_SEGMENT19, PPG_SEGMENT20 PPG_SEGMENT20, PPG_SEGMENT21 PPG_SEGMENT21, PPG_SEGMENT22 PPG_SEGMENT22, PPG_SEGMENT23 PPG_SEGMENT23, PPG_SEGMENT24 PPG_SEGMENT24, PPG_SEGMENT25 PPG_SEGMENT25, PPG_SEGMENT26 PPG_SEGMENT26, PPG_SEGMENT27 PPG_SEGMENT27, PPG_SEGMENT28 PPG_SEGMENT28, PPG_SEGMENT29 PPG_SEGMENT29, PPG_SEGMENT30 PPG_SEGMENT30 from "HR"."HR_H2PI_ASSIGNMENTS"

View Text - HTML Formatted

SELECT LAST_UPD_DATE LAST_UPD_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CLIENT_ID CLIENT_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PERSON_ID PERSON_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PRIMARY_FLAG PRIMARY_FLAG
, FREQUENCY FREQUENCY
, NORMAL_HOURS NORMAL_HOURS
, TITLE TITLE
, PAY_BASIS_ID PAY_BASIS_ID
, LOCATION_ID LOCATION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PAYROLL_ID PAYROLL_ID
, HOURLY_SALARIED_CODE HOURLY_SALARIED_CODE
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
, TIME_NORMAL_FINISH TIME_NORMAL_FINISH
, TIME_NORMAL_START TIME_NORMAL_START
, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY
, ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE_CATEGORY
, ASS_ATTRIBUTE1 ASS_ATTRIBUTE1
, ASS_ATTRIBUTE2 ASS_ATTRIBUTE2
, ASS_ATTRIBUTE3 ASS_ATTRIBUTE3
, ASS_ATTRIBUTE4 ASS_ATTRIBUTE4
, ASS_ATTRIBUTE5 ASS_ATTRIBUTE5
, ASS_ATTRIBUTE6 ASS_ATTRIBUTE6
, ASS_ATTRIBUTE7 ASS_ATTRIBUTE7
, ASS_ATTRIBUTE8 ASS_ATTRIBUTE8
, ASS_ATTRIBUTE9 ASS_ATTRIBUTE9
, ASS_ATTRIBUTE10 ASS_ATTRIBUTE10
, ASS_ATTRIBUTE11 ASS_ATTRIBUTE11
, ASS_ATTRIBUTE12 ASS_ATTRIBUTE12
, ASS_ATTRIBUTE13 ASS_ATTRIBUTE13
, ASS_ATTRIBUTE14 ASS_ATTRIBUTE14
, ASS_ATTRIBUTE15 ASS_ATTRIBUTE15
, ASS_ATTRIBUTE16 ASS_ATTRIBUTE16
, ASS_ATTRIBUTE17 ASS_ATTRIBUTE17
, ASS_ATTRIBUTE18 ASS_ATTRIBUTE18
, ASS_ATTRIBUTE19 ASS_ATTRIBUTE19
, ASS_ATTRIBUTE20 ASS_ATTRIBUTE20
, ASS_ATTRIBUTE21 ASS_ATTRIBUTE21
, ASS_ATTRIBUTE22 ASS_ATTRIBUTE22
, ASS_ATTRIBUTE23 ASS_ATTRIBUTE23
, ASS_ATTRIBUTE24 ASS_ATTRIBUTE24
, ASS_ATTRIBUTE25 ASS_ATTRIBUTE25
, ASS_ATTRIBUTE26 ASS_ATTRIBUTE26
, ASS_ATTRIBUTE27 ASS_ATTRIBUTE27
, ASS_ATTRIBUTE28 ASS_ATTRIBUTE28
, ASS_ATTRIBUTE29 ASS_ATTRIBUTE29
, ASS_ATTRIBUTE30 ASS_ATTRIBUTE30
, STATUS STATUS
, PPG_SEGMENT1 PPG_SEGMENT1
, PPG_SEGMENT2 PPG_SEGMENT2
, PPG_SEGMENT3 PPG_SEGMENT3
, PPG_SEGMENT4 PPG_SEGMENT4
, PPG_SEGMENT5 PPG_SEGMENT5
, PPG_SEGMENT6 PPG_SEGMENT6
, PPG_SEGMENT7 PPG_SEGMENT7
, PPG_SEGMENT8 PPG_SEGMENT8
, PPG_SEGMENT9 PPG_SEGMENT9
, PPG_SEGMENT10 PPG_SEGMENT10
, PPG_SEGMENT11 PPG_SEGMENT11
, PPG_SEGMENT12 PPG_SEGMENT12
, PPG_SEGMENT13 PPG_SEGMENT13
, PPG_SEGMENT14 PPG_SEGMENT14
, PPG_SEGMENT15 PPG_SEGMENT15
, PPG_SEGMENT16 PPG_SEGMENT16
, PPG_SEGMENT17 PPG_SEGMENT17
, PPG_SEGMENT18 PPG_SEGMENT18
, PPG_SEGMENT19 PPG_SEGMENT19
, PPG_SEGMENT20 PPG_SEGMENT20
, PPG_SEGMENT21 PPG_SEGMENT21
, PPG_SEGMENT22 PPG_SEGMENT22
, PPG_SEGMENT23 PPG_SEGMENT23
, PPG_SEGMENT24 PPG_SEGMENT24
, PPG_SEGMENT25 PPG_SEGMENT25
, PPG_SEGMENT26 PPG_SEGMENT26
, PPG_SEGMENT27 PPG_SEGMENT27
, PPG_SEGMENT28 PPG_SEGMENT28
, PPG_SEGMENT29 PPG_SEGMENT29
, PPG_SEGMENT30 PPG_SEGMENT30
FROM "HR"."HR_H2PI_ASSIGNMENTS"