PAY_PERSONAL_PAYMENT_METHODS

Details

Schema: FUSION
Object owner: PAY
Object type: VIEW

Columns

Name
PERSONAL_PAYMENT_METHOD_ID NAME EFFECTIVE_START_DATE EFFECTIVE_END_DATE LEGISLATIVE_DATA_GROUP_ID ORG_PAYMENT_METHOD_ID AMOUNT PERCENTAGE PRIORITY 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 RUN_TYPE_ID PPM_INFORMATION_CATEGORY PPM_INFORMATION1 PPM_INFORMATION2 PPM_INFORMATION3 PPM_INFORMATION4 PPM_INFORMATION5 PPM_INFORMATION6 PPM_INFORMATION7 PPM_INFORMATION8 PPM_INFORMATION9 PPM_INFORMATION10 PPM_INFORMATION11 PPM_INFORMATION12 PPM_INFORMATION13 PPM_INFORMATION14 PPM_INFORMATION15 PPM_INFORMATION16 PPM_INFORMATION17 PPM_INFORMATION18 PPM_INFORMATION19 PPM_INFORMATION20 PPM_INFORMATION21 PPM_INFORMATION22 PPM_INFORMATION23 PPM_INFORMATION24 PPM_INFORMATION25 PPM_INFORMATION26 PPM_INFORMATION27 PPM_INFORMATION28 PPM_INFORMATION29 PPM_INFORMATION30 PAYROLL_RELATIONSHIP_ID BANK_ACCOUNT_ID

Name

PERSONAL_PAYMENT_METHOD_ID

NAME

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

LEGISLATIVE_DATA_GROUP_ID

ORG_PAYMENT_METHOD_ID

AMOUNT

PERCENTAGE

PRIORITY

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

RUN_TYPE_ID

PPM_INFORMATION_CATEGORY

PPM_INFORMATION1

PPM_INFORMATION2

PPM_INFORMATION3

PPM_INFORMATION4

PPM_INFORMATION5

PPM_INFORMATION6

PPM_INFORMATION7

PPM_INFORMATION8

PPM_INFORMATION9

PPM_INFORMATION10

PPM_INFORMATION11

PPM_INFORMATION12

PPM_INFORMATION13

PPM_INFORMATION14

PPM_INFORMATION15

PPM_INFORMATION16

PPM_INFORMATION17

PPM_INFORMATION18

PPM_INFORMATION19

PPM_INFORMATION20

PPM_INFORMATION21

PPM_INFORMATION22

PPM_INFORMATION23

PPM_INFORMATION24

PPM_INFORMATION25

PPM_INFORMATION26

PPM_INFORMATION27

PPM_INFORMATION28

PPM_INFORMATION29

PPM_INFORMATION30

PAYROLL_RELATIONSHIP_ID

BANK_ACCOUNT_ID

Query

SQL_Statement
SELECT PAY_PERSON_PAY_METHODS_F.PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID, PAY_PERSON_PAY_METHODS_F.NAME, PAY_PERSON_PAY_METHODS_F.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, PAY_PERSON_PAY_METHODS_F.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PAY_PERSON_PAY_METHODS_F.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, PAY_PERSON_PAY_METHODS_F.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID, PAY_PERSON_PAY_METHODS_F.AMOUNT AMOUNT, PAY_PERSON_PAY_METHODS_F.PERCENTAGE PERCENTAGE, PAY_PERSON_PAY_METHODS_F.PRIORITY PRIORITY, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE1 ATTRIBUTE1, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE2 ATTRIBUTE2, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE3 ATTRIBUTE3, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE4 ATTRIBUTE4, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE5 ATTRIBUTE5, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE6 ATTRIBUTE6, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE7 ATTRIBUTE7, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE8 ATTRIBUTE8, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE9 ATTRIBUTE9, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE10 ATTRIBUTE10, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE11 ATTRIBUTE11, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE12 ATTRIBUTE12, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE13 ATTRIBUTE13, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE14 ATTRIBUTE14, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE15 ATTRIBUTE15, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE16 ATTRIBUTE16, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE17 ATTRIBUTE17, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE18 ATTRIBUTE18, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE19 ATTRIBUTE19, PAY_PERSON_PAY_METHODS_F.ATTRIBUTE20 ATTRIBUTE20, PAY_PERSON_PAY_METHODS_F.LAST_UPDATE_DATE LAST_UPDATE_DATE, PAY_PERSON_PAY_METHODS_F.LAST_UPDATED_BY LAST_UPDATED_BY, PAY_PERSON_PAY_METHODS_F.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PAY_PERSON_PAY_METHODS_F.CREATED_BY CREATED_BY, PAY_PERSON_PAY_METHODS_F.CREATION_DATE CREATION_DATE, PAY_PERSON_PAY_METHODS_F.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PAY_PERSON_PAY_METHODS_F.RUN_TYPE_ID RUN_TYPE_ID, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION_CATEGORY PPM_INFORMATION_CATEGORY, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION1 PPM_INFORMATION1, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION2 PPM_INFORMATION2, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION3 PPM_INFORMATION3, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION4 PPM_INFORMATION4, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION5 PPM_INFORMATION5, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION6 PPM_INFORMATION6, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION7 PPM_INFORMATION7, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION8 PPM_INFORMATION8, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION9 PPM_INFORMATION9, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION10 PPM_INFORMATION10, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION11 PPM_INFORMATION11, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION12 PPM_INFORMATION12, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION13 PPM_INFORMATION13, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION14 PPM_INFORMATION14, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION15 PPM_INFORMATION15, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION16 PPM_INFORMATION16, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION17 PPM_INFORMATION17, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION18 PPM_INFORMATION18, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION19 PPM_INFORMATION19, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION20 PPM_INFORMATION20, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION21 PPM_INFORMATION21, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION22 PPM_INFORMATION22, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION23 PPM_INFORMATION23, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION24 PPM_INFORMATION24, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION25 PPM_INFORMATION25, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION26 PPM_INFORMATION26, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION27 PPM_INFORMATION27, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION28 PPM_INFORMATION28, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION29 PPM_INFORMATION29, PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION30 PPM_INFORMATION30, PAY_PERSON_PAY_METHODS_F.PAYROLL_RELATIONSHIP_ID PAYROLL_RELATIONSHIP_ID, PAY_PERSON_PAY_METHODS_F.BANK_ACCOUNT_ID BANK_ACCOUNT_ID FROM PAY_PERSON_PAY_METHODS_F

SQL_Statement

SELECT

PAY_PERSON_PAY_METHODS_F.PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID,

PAY_PERSON_PAY_METHODS_F.NAME,

PAY_PERSON_PAY_METHODS_F.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

PAY_PERSON_PAY_METHODS_F.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

PAY_PERSON_PAY_METHODS_F.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

PAY_PERSON_PAY_METHODS_F.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID,

PAY_PERSON_PAY_METHODS_F.AMOUNT AMOUNT,

PAY_PERSON_PAY_METHODS_F.PERCENTAGE PERCENTAGE,

PAY_PERSON_PAY_METHODS_F.PRIORITY PRIORITY,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE1 ATTRIBUTE1,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE2 ATTRIBUTE2,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE3 ATTRIBUTE3,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE4 ATTRIBUTE4,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE5 ATTRIBUTE5,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE6 ATTRIBUTE6,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE7 ATTRIBUTE7,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE8 ATTRIBUTE8,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE9 ATTRIBUTE9,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE10 ATTRIBUTE10,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE11 ATTRIBUTE11,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE12 ATTRIBUTE12,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE13 ATTRIBUTE13,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE14 ATTRIBUTE14,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE15 ATTRIBUTE15,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE16 ATTRIBUTE16,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE17 ATTRIBUTE17,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE18 ATTRIBUTE18,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE19 ATTRIBUTE19,

PAY_PERSON_PAY_METHODS_F.ATTRIBUTE20 ATTRIBUTE20,

PAY_PERSON_PAY_METHODS_F.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PAY_PERSON_PAY_METHODS_F.LAST_UPDATED_BY LAST_UPDATED_BY,

PAY_PERSON_PAY_METHODS_F.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PAY_PERSON_PAY_METHODS_F.CREATED_BY CREATED_BY,

PAY_PERSON_PAY_METHODS_F.CREATION_DATE CREATION_DATE,

PAY_PERSON_PAY_METHODS_F.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PAY_PERSON_PAY_METHODS_F.RUN_TYPE_ID RUN_TYPE_ID,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION_CATEGORY PPM_INFORMATION_CATEGORY,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION1 PPM_INFORMATION1,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION2 PPM_INFORMATION2,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION3 PPM_INFORMATION3,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION4 PPM_INFORMATION4,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION5 PPM_INFORMATION5,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION6 PPM_INFORMATION6,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION7 PPM_INFORMATION7,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION8 PPM_INFORMATION8,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION9 PPM_INFORMATION9,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION10 PPM_INFORMATION10,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION11 PPM_INFORMATION11,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION12 PPM_INFORMATION12,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION13 PPM_INFORMATION13,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION14 PPM_INFORMATION14,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION15 PPM_INFORMATION15,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION16 PPM_INFORMATION16,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION17 PPM_INFORMATION17,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION18 PPM_INFORMATION18,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION19 PPM_INFORMATION19,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION20 PPM_INFORMATION20,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION21 PPM_INFORMATION21,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION22 PPM_INFORMATION22,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION23 PPM_INFORMATION23,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION24 PPM_INFORMATION24,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION25 PPM_INFORMATION25,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION26 PPM_INFORMATION26,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION27 PPM_INFORMATION27,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION28 PPM_INFORMATION28,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION29 PPM_INFORMATION29,

PAY_PERSON_PAY_METHODS_F.PPM_INFORMATION30 PPM_INFORMATION30,

PAY_PERSON_PAY_METHODS_F.PAYROLL_RELATIONSHIP_ID PAYROLL_RELATIONSHIP_ID,

PAY_PERSON_PAY_METHODS_F.BANK_ACCOUNT_ID BANK_ACCOUNT_ID

FROM

PAY_PERSON_PAY_METHODS_F