[Home] [Help]
View: PAY_JP_ISDF_CALC_DCT_DML_V
View Text
SELECT ROWID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ACTION_CONTEXT_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, ACTION_INFORMATION1
, ACTION_INFORMATION2
, ACTION_INFORMATION3
, ACTION_INFORMATION4
, ACTION_INFORMATION5
, ACTION_INFORMATION6
, ACTION_INFORMATION7
, ACTION_INFORMATION8
, ACTION_INFORMATION25
, ACTION_INFORMATION9
, ACTION_INFORMATION10
, ACTION_INFORMATION26
, ACTION_INFORMATION11
, ACTION_INFORMATION24
, ACTION_INFORMATION12
, ACTION_INFORMATION13
, ACTION_INFORMATION14
, ACTION_INFORMATION15
, ACTION_INFORMATION16
, ACTION_INFORMATION17
, ACTION_INFORMATION18
, ACTION_INFORMATION19
, ACTION_INFORMATION20
, ACTION_INFORMATION21
, ACTION_INFORMATION22
, ACTION_INFORMATION23
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_ACTION_INFORMATION
Columns
Name |
ROW_ID |
ACTION_INFORMATION_ID |
OBJECT_VERSION_NUMBER |
ASSIGNMENT_ACTION_ID |
ACTION_CONTEXT_TYPE |
ASSIGNMENT_ID |
EFFECTIVE_DATE |
ACTION_INFORMATION_CATEGORY |
STATUS |
LIFE_GEN_INS_PREM |
LIFE_PENS_INS_PREM |
LIFE_GEN_INS_CALC_PREM |
LIFE_PENS_INS_CALC_PREM |
LIFE_INS_DEDUCTION |
NONLIFE_LONG_INS_PREM |
NONLIFE_SHORT_INS_PREM |
EARTHQUAKE_INS_PREM |
NONLIFE_LONG_INS_CALC_PREM |
NONLIFE_SHORT_INS_CALC_PREM |
EARTHQUAKE_INS_CALC_PREM |
NONLIFE_INS_DEDUCTION |
NATIONAL_PENS_INS_PREM |
SOCIAL_INS_DEDUCTION |
MUTUAL_AID_DEDUCTION |
SP_EARNED_INCOME_CALC |
SP_BUSINESS_INCOME_CALC |
SP_MISCELLANEOUS_INCOME_CALC |
SP_DIVIDEND_INCOME_CALC |
SP_REAL_ESTATE_INCOME_CALC |
SP_RETIREMENT_INCOME_CALC |
SP_OTHER_INCOME_CALC |
SP_INCOME_CALC |
SPOUSE_INCOME |
SPOUSE_DEDUCTION |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
CREATED_BY |
CREATION_DATE |