VIEW: HR.PER_TIME_PERIODS#

Source

View Text - Preformatted

select TIME_PERIOD_ID TIME_PERIOD_ID, PAYROLL_ID PAYROLL_ID, END_DATE END_DATE, PERIOD_NAME PERIOD_NAME, PERIOD_NUM PERIOD_NUM, PERIOD_TYPE PERIOD_TYPE, START_DATE START_DATE, CUT_OFF_DATE CUT_OFF_DATE, DEFAULT_DD_DATE DEFAULT_DD_DATE, DESCRIPTION DESCRIPTION, PAY_ADVICE_DATE PAY_ADVICE_DATE, PERIOD_SET_NAME PERIOD_SET_NAME, PERIOD_YEAR PERIOD_YEAR, PROC_PERIOD_TYPE PROC_PERIOD_TYPE, QUARTER_NUM QUARTER_NUM, QUICKPAY_DISPLAY_NUMBER QUICKPAY_DISPLAY_NUMBER, REGULAR_PAYMENT_DATE REGULAR_PAYMENT_DATE, RUN_DISPLAY_NUMBER RUN_DISPLAY_NUMBER, STATUS STATUS, YEAR_NUMBER YEAR_NUMBER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REGULAR_DATE_EARNED REGULAR_DATE_EARNED, PRD_INFORMATION_CATEGORY PRD_INFORMATION_CATEGORY, PRD_INFORMATION1 PRD_INFORMATION1, PRD_INFORMATION2 PRD_INFORMATION2, PRD_INFORMATION3 PRD_INFORMATION3, PRD_INFORMATION4 PRD_INFORMATION4, PRD_INFORMATION5 PRD_INFORMATION5, PRD_INFORMATION6 PRD_INFORMATION6, PRD_INFORMATION7 PRD_INFORMATION7, PRD_INFORMATION8 PRD_INFORMATION8, PRD_INFORMATION9 PRD_INFORMATION9, PRD_INFORMATION10 PRD_INFORMATION10, PRD_INFORMATION11 PRD_INFORMATION11, PRD_INFORMATION12 PRD_INFORMATION12, PRD_INFORMATION13 PRD_INFORMATION13, PRD_INFORMATION14 PRD_INFORMATION14, PRD_INFORMATION15 PRD_INFORMATION15, PRD_INFORMATION16 PRD_INFORMATION16, PRD_INFORMATION17 PRD_INFORMATION17, PRD_INFORMATION18 PRD_INFORMATION18, PRD_INFORMATION19 PRD_INFORMATION19, PRD_INFORMATION20 PRD_INFORMATION20, PRD_INFORMATION21 PRD_INFORMATION21, PRD_INFORMATION22 PRD_INFORMATION22, PRD_INFORMATION23 PRD_INFORMATION23, PRD_INFORMATION24 PRD_INFORMATION24, PRD_INFORMATION25 PRD_INFORMATION25, PRD_INFORMATION26 PRD_INFORMATION26, PRD_INFORMATION27 PRD_INFORMATION27, PRD_INFORMATION28 PRD_INFORMATION28, PRD_INFORMATION29 PRD_INFORMATION29, PRD_INFORMATION30 PRD_INFORMATION30, TIME_DEFINITION_ID TIME_DEFINITION_ID, PAYSLIP_VIEW_DATE PAYSLIP_VIEW_DATE from "HR"."PER_TIME_PERIODS"

View Text - HTML Formatted

SELECT TIME_PERIOD_ID TIME_PERIOD_ID
, PAYROLL_ID PAYROLL_ID
, END_DATE END_DATE
, PERIOD_NAME PERIOD_NAME
, PERIOD_NUM PERIOD_NUM
, PERIOD_TYPE PERIOD_TYPE
, START_DATE START_DATE
, CUT_OFF_DATE CUT_OFF_DATE
, DEFAULT_DD_DATE DEFAULT_DD_DATE
, DESCRIPTION DESCRIPTION
, PAY_ADVICE_DATE PAY_ADVICE_DATE
, PERIOD_SET_NAME PERIOD_SET_NAME
, PERIOD_YEAR PERIOD_YEAR
, PROC_PERIOD_TYPE PROC_PERIOD_TYPE
, QUARTER_NUM QUARTER_NUM
, QUICKPAY_DISPLAY_NUMBER QUICKPAY_DISPLAY_NUMBER
, REGULAR_PAYMENT_DATE REGULAR_PAYMENT_DATE
, RUN_DISPLAY_NUMBER RUN_DISPLAY_NUMBER
, STATUS STATUS
, YEAR_NUMBER YEAR_NUMBER
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REGULAR_DATE_EARNED REGULAR_DATE_EARNED
, PRD_INFORMATION_CATEGORY PRD_INFORMATION_CATEGORY
, PRD_INFORMATION1 PRD_INFORMATION1
, PRD_INFORMATION2 PRD_INFORMATION2
, PRD_INFORMATION3 PRD_INFORMATION3
, PRD_INFORMATION4 PRD_INFORMATION4
, PRD_INFORMATION5 PRD_INFORMATION5
, PRD_INFORMATION6 PRD_INFORMATION6
, PRD_INFORMATION7 PRD_INFORMATION7
, PRD_INFORMATION8 PRD_INFORMATION8
, PRD_INFORMATION9 PRD_INFORMATION9
, PRD_INFORMATION10 PRD_INFORMATION10
, PRD_INFORMATION11 PRD_INFORMATION11
, PRD_INFORMATION12 PRD_INFORMATION12
, PRD_INFORMATION13 PRD_INFORMATION13
, PRD_INFORMATION14 PRD_INFORMATION14
, PRD_INFORMATION15 PRD_INFORMATION15
, PRD_INFORMATION16 PRD_INFORMATION16
, PRD_INFORMATION17 PRD_INFORMATION17
, PRD_INFORMATION18 PRD_INFORMATION18
, PRD_INFORMATION19 PRD_INFORMATION19
, PRD_INFORMATION20 PRD_INFORMATION20
, PRD_INFORMATION21 PRD_INFORMATION21
, PRD_INFORMATION22 PRD_INFORMATION22
, PRD_INFORMATION23 PRD_INFORMATION23
, PRD_INFORMATION24 PRD_INFORMATION24
, PRD_INFORMATION25 PRD_INFORMATION25
, PRD_INFORMATION26 PRD_INFORMATION26
, PRD_INFORMATION27 PRD_INFORMATION27
, PRD_INFORMATION28 PRD_INFORMATION28
, PRD_INFORMATION29 PRD_INFORMATION29
, PRD_INFORMATION30 PRD_INFORMATION30
, TIME_DEFINITION_ID TIME_DEFINITION_ID
, PAYSLIP_VIEW_DATE PAYSLIP_VIEW_DATE
FROM "HR"."PER_TIME_PERIODS"