[Home] [Help] [Dependency Information]
Object Name: | PAY_ALL_PAYROLLS_F1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
ROE_CONTACT_PERSON | VARCHAR2 | (150) | ||
ROE_CONTACT_PHONE | VARCHAR2 | (150) | ||
ROE_NAME_OF_ISSUER | VARCHAR2 | (150) | ||
CORRESPONDENCE_LANGUAGE | VARCHAR2 | (150) | ||
TAX_MULTIPLE_PAYMENTS_AS_ONE | VARCHAR2 | (150) | ||
TERMINATE_SEEDED_EARNINGS_BY | VARCHAR2 | (150) | ||
HR_PAYROLL_REPRESENTATIVE | VARCHAR2 | (150) | ||
USE_HOLIDAY_CARD | VARCHAR2 | (150) | ||
TAX_DAY_FORMULA | VARCHAR2 | (150) | ||
OVERTIME_SCHEME_TYPE | VARCHAR2 | (150) | ||
THRESHOLD | NUMBER | |||
ANNUAL_QUOTA | NUMBER | |||
WEEKLY_OFFSET_THRESHOLD | NUMBER | |||
BONIFICATION_METHOD | VARCHAR2 | (150) | ||
MAJORATION_METHOD | VARCHAR2 | (150) | ||
WEEKLY_COMPENSATION_THRESHOLD | NUMBER | |||
UPPER_COMPENSATION_THRESHOLD | NUMBER | |||
LOWER_COMPENSATION_FACTOR | NUMBER | |||
HIGHER_COMPENSATION_FACTOR | NUMBER | |||
OVERTIME_BAND_TABLE | VARCHAR2 | (150) | ||
REGULARISATION_PERIOD_TYPE | VARCHAR2 | (150) | ||
REGULARISATION_PERIOD_WEEKS | NUMBER | |||
REGULARISATION_THRESHOLD | NUMBER | |||
REGULARISATION_OFFSET | NUMBER | |||
REGULARISATION_PAYMENT_BASIS | VARCHAR2 | (150) | ||
REGULARISATION_START_DATE | DATE | |||
OVERTIME_FORMULA | VARCHAR2 | (150) | ||
REGULARISATION_FORMULA | VARCHAR2 | (150) | ||
ITAX_DPNT_REF_TYPE | VARCHAR2 | (150) | ||
SI_COLLECTION_TYPE | VARCHAR2 | (150) | ||
YEA_FORMULA | VARCHAR2 | (150) | ||
GEPSAN_HIWP_MR_SYNC | VARCHAR2 | (150) | ||
GEPSAN_PROC_MMDD | VARCHAR2 | (150) | ||
ADDL_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_GOV_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_HI_PREM_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_EI_PREM_FLAG | VARCHAR2 | (150) | ||
SP_TAX_EXEM_ADJ_AMOUNT | NUMBER | |||
MIN_SP_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
NP_PREM_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
ISR_TAX_RATE | VARCHAR2 | (150) | ||
ISR_TAX_SUBSIDY | VARCHAR2 | (150) | ||
ISR_CREDIT_TO_SALARY | VARCHAR2 | (150) | ||
ISR_SUBSIDY_FOR_EMPL | VARCHAR2 | (150) | ||
ISR_TAX_ANNUAL_RATE | VARCHAR2 | (150) | ||
ISR_TAX_ANNUAL_SUBSIDY | VARCHAR2 | (150) | ||
ISR_ANNUAL_CREDIT_TO_SALARY | VARCHAR2 | (150) | ||
ISR_MONTHLY_TAX_RATE | VARCHAR2 | (150) | ||
ISR_MONTHLY_TAX_SUBSIDY | VARCHAR2 | (150) | ||
ISR_MONTHLY_CREDIT_TO_SALARY | VARCHAR2 | (150) | ||
EMPLOYER | VARCHAR2 | (150) | ||
SENDER | VARCHAR2 | (150) | ||
RECEIVER | VARCHAR2 | (150) | ||
MESSAGE_TYPE | VARCHAR2 | (150) | ||
HOURS_CALCULATION_TYPE | VARCHAR2 | (150) | ||
PRE_NOTIFICATION_ALLOWED | VARCHAR2 | (150) | ||
PQP_US_MODE_OF_PAYMENT_CODE | VARCHAR2 | (150) | ||
PPG_BILLING_CD | VARCHAR2 | (150) | ||
PLAN_NO | VARCHAR2 | (150) | ||
ITERATIVE_METHOD | VARCHAR2 | (150) | ||
PRE_TAX_FIT_TO_WITHIN | NUMBER | |||
TIME_DEFINITION | VARCHAR2 | (150) | ||
PREMIUM_CALCULATION_RATE | VARCHAR2 | (150) | ||
USE_INFORMATION_HOURS_FROM | VARCHAR2 | (150) | ||
THRESHOLD_BASIS | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (2899) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, ROE_CONTACT_PERSON
, ROE_CONTACT_PHONE
, ROE_NAME_OF_ISSUER
, CORRESPONDENCE_LANGUAGE
, TAX_MULTIPLE_PAYMENTS_AS_ONE
, TERMINATE_SEEDED_EARNINGS_BY
, HR_PAYROLL_REPRESENTATIVE
, USE_HOLIDAY_CARD
, TAX_DAY_FORMULA
, OVERTIME_SCHEME_TYPE
, THRESHOLD
, ANNUAL_QUOTA
, WEEKLY_OFFSET_THRESHOLD
, BONIFICATION_METHOD
, MAJORATION_METHOD
, WEEKLY_COMPENSATION_THRESHOLD
, UPPER_COMPENSATION_THRESHOLD
, LOWER_COMPENSATION_FACTOR
, HIGHER_COMPENSATION_FACTOR
, OVERTIME_BAND_TABLE
, REGULARISATION_PERIOD_TYPE
, REGULARISATION_PERIOD_WEEKS
, REGULARISATION_THRESHOLD
, REGULARISATION_OFFSET
, REGULARISATION_PAYMENT_BASIS
, REGULARISATION_START_DATE
, OVERTIME_FORMULA
, REGULARISATION_FORMULA
, ITAX_DPNT_REF_TYPE
, SI_COLLECTION_TYPE
, YEA_FORMULA
, GEPSAN_HIWP_MR_SYNC
, GEPSAN_PROC_MMDD
, ADDL_TAX_EXEM_FLAG
, SP_TAX_EXEM_GOV_FLAG
, SP_TAX_EXEM_HI_PREM_FLAG
, SP_TAX_EXEM_EI_PREM_FLAG
, SP_TAX_EXEM_ADJ_AMOUNT
, MIN_SP_TAX_EXEM_FLAG
, NP_PREM_TAX_EXEM_FLAG
, ISR_TAX_RATE
, ISR_TAX_SUBSIDY
, ISR_CREDIT_TO_SALARY
, ISR_SUBSIDY_FOR_EMPL
, ISR_TAX_ANNUAL_RATE
, ISR_TAX_ANNUAL_SUBSIDY
, ISR_ANNUAL_CREDIT_TO_SALARY
, ISR_MONTHLY_TAX_RATE
, ISR_MONTHLY_TAX_SUBSIDY
, ISR_MONTHLY_CREDIT_TO_SALARY
, EMPLOYER
, SENDER
, RECEIVER
, MESSAGE_TYPE
, HOURS_CALCULATION_TYPE
, PRE_NOTIFICATION_ALLOWED
, PQP_US_MODE_OF_PAYMENT_CODE
, PPG_BILLING_CD
, PLAN_NO
, ITERATIVE_METHOD
, PRE_TAX_FIT_TO_WITHIN
, TIME_DEFINITION
, PREMIUM_CALCULATION_RATE
, USE_INFORMATION_HOURS_FROM
, THRESHOLD_BASIS
, CONCATENATED_SEGMENTS
FROM APPS.PAY_ALL_PAYROLLS_F1_DFV;
|
|
|