PAY_PAYROLL_SECURED_LIST

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
PAYROLL_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE PAYROLL_NAME LEGISLATIVE_DATA_GROUP_ID CONSOLIDATION_SET_ID GL_SET_OF_BOOKS_ID PERIOD_TYPE TIME_DEFINITION_ID FIRST_PERIOD_END_DATE NUMBER_OF_YEARS PERIOD_RESET_YEARS CUT_OFF_DATE_OFFSET REGULAR_EARN_DATE_OFFSET REGULAR_PROCESS_DATE_OFFSET DEFAULT_PAYDATE_OFFSET PAYSLIP_VIEW_DATE_OFFSET NEGATIVE_PAY_ALLOWED_FLAG DEFAULT_PAYMENT_METHOD_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER BASE_OFFSETS PAYMENTS_WRT PAYDATE_BASE_WRT PAYSLIP_BASE_WRT CUTOFF_BASE_WRT PROCESS_BASE_WRT EARN_BASE_WRT PAYSLIP_BASE_DATE CUTOFF_BASE_DATE PROCESS_BASE_DATE EARN_BASE_DATE PAYDATE_BASE_DATE PROCESS_FALLS EARN_FALLS PAYDATE_FALLS PAYSLIP_FALLS CUTOFF_FALLS PAYSLIP_OFFSET EARN_OFFSET PROCESS_OFFSET CUTOFF_OFFSET PAYDATE_OFFSET FIXED_DATE PAYSLIP_FIXED_DATE CUTOFF_FIXED_DATE PROCESS_FIXED_DATE EARN_FIXED_DATE PAYDATE_FIXED_DATE PRL_INFORMATION_CATEGORY PRL_INFORMATION1 PRL_INFORMATION2 PRL_INFORMATION3 PRL_INFORMATION4 PRL_INFORMATION5 PRL_INFORMATION6 PRL_INFORMATION7 PRL_INFORMATION8 PRL_INFORMATION9 PRL_INFORMATION10 PRL_INFORMATION11 PRL_INFORMATION12 PRL_INFORMATION13 PRL_INFORMATION14 PRL_INFORMATION15 PRL_INFORMATION16 PRL_INFORMATION17 PRL_INFORMATION18 PRL_INFORMATION19 PRL_INFORMATION20 PRL_INFORMATION21 PRL_INFORMATION22 PRL_INFORMATION23 PRL_INFORMATION24 PRL_INFORMATION25 PRL_INFORMATION26 PRL_INFORMATION27 PRL_INFORMATION28 PRL_INFORMATION29 PRL_INFORMATION30 PRL_INFORMATION_NUMBER1 PRL_INFORMATION_NUMBER2 PRL_INFORMATION_NUMBER3 PRL_INFORMATION_NUMBER4 PRL_INFORMATION_NUMBER5 PRL_INFORMATION_NUMBER6 PRL_INFORMATION_NUMBER7 PRL_INFORMATION_NUMBER8 PRL_INFORMATION_NUMBER9 PRL_INFORMATION_NUMBER10 PRL_INFORMATION_NUMBER11 PRL_INFORMATION_NUMBER12 PRL_INFORMATION_NUMBER13 PRL_INFORMATION_NUMBER14 PRL_INFORMATION_NUMBER15 PRL_INFORMATION_NUMBER16 PRL_INFORMATION_NUMBER17 PRL_INFORMATION_NUMBER18 PRL_INFORMATION_NUMBER19 PRL_INFORMATION_NUMBER20 PRL_INFORMATION_DATE1 PRL_INFORMATION_DATE2 PRL_INFORMATION_DATE3 PRL_INFORMATION_DATE4 PRL_INFORMATION_DATE5 PRL_INFORMATION_DATE6 PRL_INFORMATION_DATE7 PRL_INFORMATION_DATE8 PRL_INFORMATION_DATE9 PRL_INFORMATION_DATE10 PRL_INFORMATION_DATE11 PRL_INFORMATION_DATE12 PRL_INFORMATION_DATE13 PRL_INFORMATION_DATE14 PRL_INFORMATION_DATE15

Name

PAYROLL_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

PAYROLL_NAME

LEGISLATIVE_DATA_GROUP_ID

CONSOLIDATION_SET_ID

GL_SET_OF_BOOKS_ID

PERIOD_TYPE

TIME_DEFINITION_ID

FIRST_PERIOD_END_DATE

NUMBER_OF_YEARS

PERIOD_RESET_YEARS

CUT_OFF_DATE_OFFSET

REGULAR_EARN_DATE_OFFSET

REGULAR_PROCESS_DATE_OFFSET

DEFAULT_PAYDATE_OFFSET

PAYSLIP_VIEW_DATE_OFFSET

NEGATIVE_PAY_ALLOWED_FLAG

DEFAULT_PAYMENT_METHOD_ID

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

OBJECT_VERSION_NUMBER

BASE_OFFSETS

PAYMENTS_WRT

PAYDATE_BASE_WRT

PAYSLIP_BASE_WRT

CUTOFF_BASE_WRT

PROCESS_BASE_WRT

EARN_BASE_WRT

PAYSLIP_BASE_DATE

CUTOFF_BASE_DATE

PROCESS_BASE_DATE

EARN_BASE_DATE

PAYDATE_BASE_DATE

PROCESS_FALLS

EARN_FALLS

PAYDATE_FALLS

PAYSLIP_FALLS

CUTOFF_FALLS

PAYSLIP_OFFSET

EARN_OFFSET

PROCESS_OFFSET

CUTOFF_OFFSET

PAYDATE_OFFSET

FIXED_DATE

PAYSLIP_FIXED_DATE

CUTOFF_FIXED_DATE

PROCESS_FIXED_DATE

EARN_FIXED_DATE

PAYDATE_FIXED_DATE

PRL_INFORMATION_CATEGORY

PRL_INFORMATION1

PRL_INFORMATION2

PRL_INFORMATION3

PRL_INFORMATION4

PRL_INFORMATION5

PRL_INFORMATION6

PRL_INFORMATION7

PRL_INFORMATION8

PRL_INFORMATION9

PRL_INFORMATION10

PRL_INFORMATION11

PRL_INFORMATION12

PRL_INFORMATION13

PRL_INFORMATION14

PRL_INFORMATION15

PRL_INFORMATION16

PRL_INFORMATION17

PRL_INFORMATION18

PRL_INFORMATION19

PRL_INFORMATION20

PRL_INFORMATION21

PRL_INFORMATION22

PRL_INFORMATION23

PRL_INFORMATION24

PRL_INFORMATION25

PRL_INFORMATION26

PRL_INFORMATION27

PRL_INFORMATION28

PRL_INFORMATION29

PRL_INFORMATION30

PRL_INFORMATION_NUMBER1

PRL_INFORMATION_NUMBER2

PRL_INFORMATION_NUMBER3

PRL_INFORMATION_NUMBER4

PRL_INFORMATION_NUMBER5

PRL_INFORMATION_NUMBER6

PRL_INFORMATION_NUMBER7

PRL_INFORMATION_NUMBER8

PRL_INFORMATION_NUMBER9

PRL_INFORMATION_NUMBER10

PRL_INFORMATION_NUMBER11

PRL_INFORMATION_NUMBER12

PRL_INFORMATION_NUMBER13

PRL_INFORMATION_NUMBER14

PRL_INFORMATION_NUMBER15

PRL_INFORMATION_NUMBER16

PRL_INFORMATION_NUMBER17

PRL_INFORMATION_NUMBER18

PRL_INFORMATION_NUMBER19

PRL_INFORMATION_NUMBER20

PRL_INFORMATION_DATE1

PRL_INFORMATION_DATE2

PRL_INFORMATION_DATE3

PRL_INFORMATION_DATE4

PRL_INFORMATION_DATE5

PRL_INFORMATION_DATE6

PRL_INFORMATION_DATE7

PRL_INFORMATION_DATE8

PRL_INFORMATION_DATE9

PRL_INFORMATION_DATE10

PRL_INFORMATION_DATE11

PRL_INFORMATION_DATE12

PRL_INFORMATION_DATE13

PRL_INFORMATION_DATE14

PRL_INFORMATION_DATE15

Query

SQL_Statement
SELECT PAY_ALL_PAYROLLS_F1.PAYROLL_ID PAYROLL_ID, PAY_ALL_PAYROLLS_F1.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, PAY_ALL_PAYROLLS_F1.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PAY_ALL_PAYROLLS_F1.PAYROLL_NAME PAYROLL_NAME, PAY_ALL_PAYROLLS_F1.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, PAY_ALL_PAYROLLS_F1.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID, PAY_ALL_PAYROLLS_F1.GL_SET_OF_BOOKS_ID GL_SET_OF_BOOKS_ID, PAY_ALL_PAYROLLS_F1.PERIOD_TYPE PERIOD_TYPE, PAY_ALL_PAYROLLS_F1.TIME_DEFINITION_ID TIME_DEFINITION_ID, PAY_ALL_PAYROLLS_F1.FIRST_PERIOD_END_DATE FIRST_PERIOD_END_DATE, PAY_ALL_PAYROLLS_F1.NUMBER_OF_YEARS NUMBER_OF_YEARS, PAY_ALL_PAYROLLS_F1.PERIOD_RESET_YEARS PERIOD_RESET_YEARS, PAY_ALL_PAYROLLS_F1.CUT_OFF_DATE_OFFSET CUT_OFF_DATE_OFFSET, PAY_ALL_PAYROLLS_F1.REGULAR_EARN_DATE_OFFSET REGULAR_EARN_DATE_OFFSET, PAY_ALL_PAYROLLS_F1.REGULAR_PROCESS_DATE_OFFSET REGULAR_PROCESS_DATE_OFFSET, PAY_ALL_PAYROLLS_F1.DEFAULT_PAYDATE_OFFSET DEFAULT_PAYDATE_OFFSET, PAY_ALL_PAYROLLS_F1.PAYSLIP_VIEW_DATE_OFFSET PAYSLIP_VIEW_DATE_OFFSET, PAY_ALL_PAYROLLS_F1.NEGATIVE_PAY_ALLOWED_FLAG NEGATIVE_PAY_ALLOWED_FLAG, PAY_ALL_PAYROLLS_F1.DEFAULT_PAYMENT_METHOD_ID DEFAULT_PAYMENT_METHOD_ID, PAY_ALL_PAYROLLS_F1.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PAY_ALL_PAYROLLS_F1.ATTRIBUTE1 ATTRIBUTE1, PAY_ALL_PAYROLLS_F1.ATTRIBUTE2 ATTRIBUTE2, PAY_ALL_PAYROLLS_F1.ATTRIBUTE3 ATTRIBUTE3, PAY_ALL_PAYROLLS_F1.ATTRIBUTE4 ATTRIBUTE4, PAY_ALL_PAYROLLS_F1.ATTRIBUTE5 ATTRIBUTE5, PAY_ALL_PAYROLLS_F1.ATTRIBUTE6 ATTRIBUTE6, PAY_ALL_PAYROLLS_F1.ATTRIBUTE7 ATTRIBUTE7, PAY_ALL_PAYROLLS_F1.ATTRIBUTE8 ATTRIBUTE8, PAY_ALL_PAYROLLS_F1.ATTRIBUTE9 ATTRIBUTE9, PAY_ALL_PAYROLLS_F1.ATTRIBUTE10 ATTRIBUTE10, PAY_ALL_PAYROLLS_F1.ATTRIBUTE11 ATTRIBUTE11, PAY_ALL_PAYROLLS_F1.ATTRIBUTE12 ATTRIBUTE12, PAY_ALL_PAYROLLS_F1.ATTRIBUTE13 ATTRIBUTE13, PAY_ALL_PAYROLLS_F1.ATTRIBUTE14 ATTRIBUTE14, PAY_ALL_PAYROLLS_F1.ATTRIBUTE15 ATTRIBUTE15, PAY_ALL_PAYROLLS_F1.ATTRIBUTE16 ATTRIBUTE16, PAY_ALL_PAYROLLS_F1.ATTRIBUTE17 ATTRIBUTE17, PAY_ALL_PAYROLLS_F1.ATTRIBUTE18 ATTRIBUTE18, PAY_ALL_PAYROLLS_F1.ATTRIBUTE19 ATTRIBUTE19, PAY_ALL_PAYROLLS_F1.ATTRIBUTE20 ATTRIBUTE20, PAY_ALL_PAYROLLS_F1.LAST_UPDATE_DATE LAST_UPDATE_DATE, PAY_ALL_PAYROLLS_F1.LAST_UPDATED_BY LAST_UPDATED_BY, PAY_ALL_PAYROLLS_F1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PAY_ALL_PAYROLLS_F1.CREATED_BY CREATED_BY, PAY_ALL_PAYROLLS_F1.CREATION_DATE CREATION_DATE, PAY_ALL_PAYROLLS_F1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PAY_ALL_PAYROLLS_F1.BASE_OFFSETS BASE_OFFSETS, PAY_ALL_PAYROLLS_F1.PAYMENTS_WRT PAYMENTS_WRT, PAY_ALL_PAYROLLS_F1.PAYDATE_BASE_WRT PAYDATE_BASE_WRT, PAY_ALL_PAYROLLS_F1.PAYSLIP_BASE_WRT PAYSLIP_BASE_WRT, PAY_ALL_PAYROLLS_F1.CUTOFF_BASE_WRT CUTOFF_BASE_WRT, PAY_ALL_PAYROLLS_F1.PROCESS_BASE_WRT PROCESS_BASE_WRT, PAY_ALL_PAYROLLS_F1.EARN_BASE_WRT EARN_BASE_WRT, PAY_ALL_PAYROLLS_F1.PAYSLIP_BASE_DATE PAYSLIP_BASE_DATE, PAY_ALL_PAYROLLS_F1.CUTOFF_BASE_DATE CUTOFF_BASE_DATE, PAY_ALL_PAYROLLS_F1.PROCESS_BASE_DATE PROCESS_BASE_DATE, PAY_ALL_PAYROLLS_F1.EARN_BASE_DATE EARN_BASE_DATE, PAY_ALL_PAYROLLS_F1.PAYDATE_BASE_DATE PAYDATE_BASE_DATE, PAY_ALL_PAYROLLS_F1.PROCESS_FALLS PROCESS_FALLS, PAY_ALL_PAYROLLS_F1.EARN_FALLS EARN_FALLS, PAY_ALL_PAYROLLS_F1.PAYDATE_FALLS PAYDATE_FALLS, PAY_ALL_PAYROLLS_F1.PAYSLIP_FALLS PAYSLIP_FALLS, PAY_ALL_PAYROLLS_F1.CUTOFF_FALLS CUTOFF_FALLS, PAY_ALL_PAYROLLS_F1.PAYSLIP_OFFSET PAYSLIP_OFFSET, PAY_ALL_PAYROLLS_F1.EARN_OFFSET EARN_OFFSET, PAY_ALL_PAYROLLS_F1.PROCESS_OFFSET PROCESS_OFFSET, PAY_ALL_PAYROLLS_F1.CUTOFF_OFFSET CUTOFF_OFFSET, PAY_ALL_PAYROLLS_F1.PAYDATE_OFFSET PAYDATE_OFFSET, PAY_ALL_PAYROLLS_F1.FIXED_DATE FIXED_DATE, PAY_ALL_PAYROLLS_F1.PAYSLIP_FIXED_DATE PAYSLIP_FIXED_DATE, PAY_ALL_PAYROLLS_F1.CUTOFF_FIXED_DATE CUTOFF_FIXED_DATE, PAY_ALL_PAYROLLS_F1.PROCESS_FIXED_DATE PROCESS_FIXED_DATE, PAY_ALL_PAYROLLS_F1.EARN_FIXED_DATE EARN_FIXED_DATE, PAY_ALL_PAYROLLS_F1.PAYDATE_FIXED_DATE PAYDATE_FIXED_DATE, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_CATEGORY PRL_INFORMATION_CATEGORY, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION1 PRL_INFORMATION1, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION2 PRL_INFORMATION2, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION3 PRL_INFORMATION3, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION4 PRL_INFORMATION4, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION5 PRL_INFORMATION5, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION6 PRL_INFORMATION6, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION7 PRL_INFORMATION7, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION8 PRL_INFORMATION8, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION9 PRL_INFORMATION9, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION10 PRL_INFORMATION10, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION11 PRL_INFORMATION11, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION12 PRL_INFORMATION12, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION13 PRL_INFORMATION13, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION14 PRL_INFORMATION14, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION15 PRL_INFORMATION15, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION16 PRL_INFORMATION16, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION17 PRL_INFORMATION17, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION18 PRL_INFORMATION18, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION19 PRL_INFORMATION19, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION20 PRL_INFORMATION20, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION21 PRL_INFORMATION21, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION22 PRL_INFORMATION22, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION23 PRL_INFORMATION23, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION24 PRL_INFORMATION24, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION25 PRL_INFORMATION25, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION26 PRL_INFORMATION26, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION27 PRL_INFORMATION27, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION28 PRL_INFORMATION28, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION29 PRL_INFORMATION29, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION30 PRL_INFORMATION30, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER1 PRL_INFORMATION_NUMBER1, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER2 PRL_INFORMATION_NUMBER2, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER3 PRL_INFORMATION_NUMBER3, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER4 PRL_INFORMATION_NUMBER4, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER5 PRL_INFORMATION_NUMBER5, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER6 PRL_INFORMATION_NUMBER6, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER7 PRL_INFORMATION_NUMBER7, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER8 PRL_INFORMATION_NUMBER8, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER9 PRL_INFORMATION_NUMBER9, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER10 PRL_INFORMATION_NUMBER10, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER11 PRL_INFORMATION_NUMBER11, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER12 PRL_INFORMATION_NUMBER12, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER13 PRL_INFORMATION_NUMBER13, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER14 PRL_INFORMATION_NUMBER14, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER15 PRL_INFORMATION_NUMBER15, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER16 PRL_INFORMATION_NUMBER16, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER17 PRL_INFORMATION_NUMBER17, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER18 PRL_INFORMATION_NUMBER18, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER19 PRL_INFORMATION_NUMBER19, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER20 PRL_INFORMATION_NUMBER20, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE1 PRL_INFORMATION_DATE1, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE2 PRL_INFORMATION_DATE2, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE3 PRL_INFORMATION_DATE3, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE4 PRL_INFORMATION_DATE4, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE5 PRL_INFORMATION_DATE5, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE6 PRL_INFORMATION_DATE6, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE7 PRL_INFORMATION_DATE7, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE8 PRL_INFORMATION_DATE8, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE9 PRL_INFORMATION_DATE9, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE10 PRL_INFORMATION_DATE10, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE11 PRL_INFORMATION_DATE11, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE12 PRL_INFORMATION_DATE12, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE13 PRL_INFORMATION_DATE13, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE14 PRL_INFORMATION_DATE14, PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE15 PRL_INFORMATION_DATE15 FROM PAY_ALL_PAYROLLS_F PAY_ALL_PAYROLLS_F1

SQL_Statement

SELECT

PAY_ALL_PAYROLLS_F1.PAYROLL_ID PAYROLL_ID,

PAY_ALL_PAYROLLS_F1.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

PAY_ALL_PAYROLLS_F1.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

PAY_ALL_PAYROLLS_F1.PAYROLL_NAME PAYROLL_NAME,

PAY_ALL_PAYROLLS_F1.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

PAY_ALL_PAYROLLS_F1.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID,

PAY_ALL_PAYROLLS_F1.GL_SET_OF_BOOKS_ID GL_SET_OF_BOOKS_ID,

PAY_ALL_PAYROLLS_F1.PERIOD_TYPE PERIOD_TYPE,

PAY_ALL_PAYROLLS_F1.TIME_DEFINITION_ID TIME_DEFINITION_ID,

PAY_ALL_PAYROLLS_F1.FIRST_PERIOD_END_DATE FIRST_PERIOD_END_DATE,

PAY_ALL_PAYROLLS_F1.NUMBER_OF_YEARS NUMBER_OF_YEARS,

PAY_ALL_PAYROLLS_F1.PERIOD_RESET_YEARS PERIOD_RESET_YEARS,

PAY_ALL_PAYROLLS_F1.CUT_OFF_DATE_OFFSET CUT_OFF_DATE_OFFSET,

PAY_ALL_PAYROLLS_F1.REGULAR_EARN_DATE_OFFSET REGULAR_EARN_DATE_OFFSET,

PAY_ALL_PAYROLLS_F1.REGULAR_PROCESS_DATE_OFFSET REGULAR_PROCESS_DATE_OFFSET,

PAY_ALL_PAYROLLS_F1.DEFAULT_PAYDATE_OFFSET DEFAULT_PAYDATE_OFFSET,

PAY_ALL_PAYROLLS_F1.PAYSLIP_VIEW_DATE_OFFSET PAYSLIP_VIEW_DATE_OFFSET,

PAY_ALL_PAYROLLS_F1.NEGATIVE_PAY_ALLOWED_FLAG NEGATIVE_PAY_ALLOWED_FLAG,

PAY_ALL_PAYROLLS_F1.DEFAULT_PAYMENT_METHOD_ID DEFAULT_PAYMENT_METHOD_ID,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE1 ATTRIBUTE1,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE2 ATTRIBUTE2,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE3 ATTRIBUTE3,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE4 ATTRIBUTE4,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE5 ATTRIBUTE5,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE6 ATTRIBUTE6,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE7 ATTRIBUTE7,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE8 ATTRIBUTE8,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE9 ATTRIBUTE9,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE10 ATTRIBUTE10,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE11 ATTRIBUTE11,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE12 ATTRIBUTE12,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE13 ATTRIBUTE13,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE14 ATTRIBUTE14,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE15 ATTRIBUTE15,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE16 ATTRIBUTE16,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE17 ATTRIBUTE17,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE18 ATTRIBUTE18,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE19 ATTRIBUTE19,

PAY_ALL_PAYROLLS_F1.ATTRIBUTE20 ATTRIBUTE20,

PAY_ALL_PAYROLLS_F1.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PAY_ALL_PAYROLLS_F1.LAST_UPDATED_BY LAST_UPDATED_BY,

PAY_ALL_PAYROLLS_F1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PAY_ALL_PAYROLLS_F1.CREATED_BY CREATED_BY,

PAY_ALL_PAYROLLS_F1.CREATION_DATE CREATION_DATE,

PAY_ALL_PAYROLLS_F1.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PAY_ALL_PAYROLLS_F1.BASE_OFFSETS BASE_OFFSETS,

PAY_ALL_PAYROLLS_F1.PAYMENTS_WRT PAYMENTS_WRT,

PAY_ALL_PAYROLLS_F1.PAYDATE_BASE_WRT PAYDATE_BASE_WRT,

PAY_ALL_PAYROLLS_F1.PAYSLIP_BASE_WRT PAYSLIP_BASE_WRT,

PAY_ALL_PAYROLLS_F1.CUTOFF_BASE_WRT CUTOFF_BASE_WRT,

PAY_ALL_PAYROLLS_F1.PROCESS_BASE_WRT PROCESS_BASE_WRT,

PAY_ALL_PAYROLLS_F1.EARN_BASE_WRT EARN_BASE_WRT,

PAY_ALL_PAYROLLS_F1.PAYSLIP_BASE_DATE PAYSLIP_BASE_DATE,

PAY_ALL_PAYROLLS_F1.CUTOFF_BASE_DATE CUTOFF_BASE_DATE,

PAY_ALL_PAYROLLS_F1.PROCESS_BASE_DATE PROCESS_BASE_DATE,

PAY_ALL_PAYROLLS_F1.EARN_BASE_DATE EARN_BASE_DATE,

PAY_ALL_PAYROLLS_F1.PAYDATE_BASE_DATE PAYDATE_BASE_DATE,

PAY_ALL_PAYROLLS_F1.PROCESS_FALLS PROCESS_FALLS,

PAY_ALL_PAYROLLS_F1.EARN_FALLS EARN_FALLS,

PAY_ALL_PAYROLLS_F1.PAYDATE_FALLS PAYDATE_FALLS,

PAY_ALL_PAYROLLS_F1.PAYSLIP_FALLS PAYSLIP_FALLS,

PAY_ALL_PAYROLLS_F1.CUTOFF_FALLS CUTOFF_FALLS,

PAY_ALL_PAYROLLS_F1.PAYSLIP_OFFSET PAYSLIP_OFFSET,

PAY_ALL_PAYROLLS_F1.EARN_OFFSET EARN_OFFSET,

PAY_ALL_PAYROLLS_F1.PROCESS_OFFSET PROCESS_OFFSET,

PAY_ALL_PAYROLLS_F1.CUTOFF_OFFSET CUTOFF_OFFSET,

PAY_ALL_PAYROLLS_F1.PAYDATE_OFFSET PAYDATE_OFFSET,

PAY_ALL_PAYROLLS_F1.FIXED_DATE FIXED_DATE,

PAY_ALL_PAYROLLS_F1.PAYSLIP_FIXED_DATE PAYSLIP_FIXED_DATE,

PAY_ALL_PAYROLLS_F1.CUTOFF_FIXED_DATE CUTOFF_FIXED_DATE,

PAY_ALL_PAYROLLS_F1.PROCESS_FIXED_DATE PROCESS_FIXED_DATE,

PAY_ALL_PAYROLLS_F1.EARN_FIXED_DATE EARN_FIXED_DATE,

PAY_ALL_PAYROLLS_F1.PAYDATE_FIXED_DATE PAYDATE_FIXED_DATE,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_CATEGORY PRL_INFORMATION_CATEGORY,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION1 PRL_INFORMATION1,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION2 PRL_INFORMATION2,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION3 PRL_INFORMATION3,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION4 PRL_INFORMATION4,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION5 PRL_INFORMATION5,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION6 PRL_INFORMATION6,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION7 PRL_INFORMATION7,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION8 PRL_INFORMATION8,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION9 PRL_INFORMATION9,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION10 PRL_INFORMATION10,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION11 PRL_INFORMATION11,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION12 PRL_INFORMATION12,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION13 PRL_INFORMATION13,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION14 PRL_INFORMATION14,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION15 PRL_INFORMATION15,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION16 PRL_INFORMATION16,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION17 PRL_INFORMATION17,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION18 PRL_INFORMATION18,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION19 PRL_INFORMATION19,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION20 PRL_INFORMATION20,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION21 PRL_INFORMATION21,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION22 PRL_INFORMATION22,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION23 PRL_INFORMATION23,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION24 PRL_INFORMATION24,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION25 PRL_INFORMATION25,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION26 PRL_INFORMATION26,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION27 PRL_INFORMATION27,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION28 PRL_INFORMATION28,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION29 PRL_INFORMATION29,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION30 PRL_INFORMATION30,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER1 PRL_INFORMATION_NUMBER1,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER2 PRL_INFORMATION_NUMBER2,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER3 PRL_INFORMATION_NUMBER3,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER4 PRL_INFORMATION_NUMBER4,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER5 PRL_INFORMATION_NUMBER5,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER6 PRL_INFORMATION_NUMBER6,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER7 PRL_INFORMATION_NUMBER7,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER8 PRL_INFORMATION_NUMBER8,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER9 PRL_INFORMATION_NUMBER9,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER10 PRL_INFORMATION_NUMBER10,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER11 PRL_INFORMATION_NUMBER11,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER12 PRL_INFORMATION_NUMBER12,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER13 PRL_INFORMATION_NUMBER13,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER14 PRL_INFORMATION_NUMBER14,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER15 PRL_INFORMATION_NUMBER15,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER16 PRL_INFORMATION_NUMBER16,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER17 PRL_INFORMATION_NUMBER17,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER18 PRL_INFORMATION_NUMBER18,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER19 PRL_INFORMATION_NUMBER19,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_NUMBER20 PRL_INFORMATION_NUMBER20,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE1 PRL_INFORMATION_DATE1,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE2 PRL_INFORMATION_DATE2,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE3 PRL_INFORMATION_DATE3,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE4 PRL_INFORMATION_DATE4,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE5 PRL_INFORMATION_DATE5,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE6 PRL_INFORMATION_DATE6,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE7 PRL_INFORMATION_DATE7,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE8 PRL_INFORMATION_DATE8,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE9 PRL_INFORMATION_DATE9,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE10 PRL_INFORMATION_DATE10,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE11 PRL_INFORMATION_DATE11,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE12 PRL_INFORMATION_DATE12,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE13 PRL_INFORMATION_DATE13,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE14 PRL_INFORMATION_DATE14,

PAY_ALL_PAYROLLS_F1.PRL_INFORMATION_DATE15 PRL_INFORMATION_DATE15

FROM

PAY_ALL_PAYROLLS_F PAY_ALL_PAYROLLS_F1