[Home] [Help] [Dependency Information]
Object Name: | PAY_GB_EPS_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EPS_RECORD_ID | NUMBER | Yes | ||
EMP_PAYE_REFERENCE | VARCHAR2 | (150) | Yes | |
ACCOUNT_OFFICE_NUMBER | VARCHAR2 | (150) | ||
EMPLOYER_NAME | VARCHAR2 | (240) | ||
ECON_NUMBER | VARCHAR2 | (150) | ||
EFFECTIVE_DATE | DATE | Yes | ||
RELATED_TAX_YEAR | NUMBER | (4) | ||
SMP_SAP_SPP_RECOVERY | NUMBER | (7) | ||
SSP_RECOVERY | NUMBER | (7) | ||
NIC_RECOVERY | NUMBER | (7) | ||
TAX_FREE_PYMT | VARCHAR2 | (1) | ||
EMP_THIRD_PARTY | VARCHAR2 | (1) | ||
EXP_BEN_OTHERS | VARCHAR2 | (1) | ||
P11D_DUE | VARCHAR2 | (1) | ||
EMP_OUTSIDE_UK | VARCHAR2 | (1) | ||
PAYMENT_DUE | VARCHAR2 | (1) | ||
FINAL_SUBMISSION_CEASED | VARCHAR2 | (1) | ||
FINAL_SUBMISSION_YEAR | VARCHAR2 | (1) | ||
SERVICE_COMPANY | VARCHAR2 | (1) | ||
SMP_AMT_RECOVERED | NUMBER | (10) | ||
SAP_AMT_RECOVERED | NUMBER | (10) | ||
OSPP_AMT_RECOVERED | NUMBER | (10) | ||
ASPP_AMT_RECOVERED | NUMBER | (10) | ||
SSP_AMT_RECOVERED | NUMBER | (10) | ||
NIC_COMP_SMP | NUMBER | (10) | ||
NIC_COMP_SAP | NUMBER | (10) | ||
NIC_COMP_OSPP | NUMBER | (10) | ||
NIC_COMP_ASPP | NUMBER | (10) | ||
NIC_COMP_SSP | NUMBER | (10) | ||
SMP_AMT_RECOVERED_CALC | NUMBER | (10) | ||
SAP_AMT_RECOVERED_CALC | NUMBER | (10) | ||
OSPP_AMT_RECOVERED_CALC | NUMBER | (10) | ||
ASPP_AMT_RECOVERED_CALC | NUMBER | (10) | ||
SSP_AMT_RECOVERED_CALC | NUMBER | (10) | ||
NIC_COMP_SMP_CALC | NUMBER | (10) | ||
NIC_COMP_SAP_CALC | NUMBER | (10) | ||
NIC_COMP_OSPP_CALC | NUMBER | (10) | ||
NIC_COMP_ASPP_CALC | NUMBER | (10) | ||
NIC_COMP_SSP_CALC | NUMBER | (10) | ||
CIS_DEDUCTIONS_STUFF | NUMBER | (12) | ||
NIC_HOLIDAY_VAL | NUMBER | (11) | ||
ADV_FROM_HMRC | NUMBER | (10) | ||
CREATED_DATE | DATE | |||
LAST_UPDATED_DATE | DATE | |||
STATUS | VARCHAR2 | (15) | ||
USER_ID | NUMBER | (15) | ||
APPROVER_ID | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
DATE_SCHEME_CEASED | DATE | |||
NO_PAYMENT_DATE_FROM | DATE | |||
NO_PAYMENT_DATE_TO | DATE | |||
PERIOD_OF_INACTIVITY_FROM | DATE | |||
PERIOD_OF_INACTIVITY_TO | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT EPS_RECORD_ID
, EMP_PAYE_REFERENCE
, ACCOUNT_OFFICE_NUMBER
, EMPLOYER_NAME
, ECON_NUMBER
, EFFECTIVE_DATE
, RELATED_TAX_YEAR
, SMP_SAP_SPP_RECOVERY
, SSP_RECOVERY
, NIC_RECOVERY
, TAX_FREE_PYMT
, EMP_THIRD_PARTY
, EXP_BEN_OTHERS
, P11D_DUE
, EMP_OUTSIDE_UK
, PAYMENT_DUE
, FINAL_SUBMISSION_CEASED
, FINAL_SUBMISSION_YEAR
, SERVICE_COMPANY
, SMP_AMT_RECOVERED
, SAP_AMT_RECOVERED
, OSPP_AMT_RECOVERED
, ASPP_AMT_RECOVERED
, SSP_AMT_RECOVERED
, NIC_COMP_SMP
, NIC_COMP_SAP
, NIC_COMP_OSPP
, NIC_COMP_ASPP
, NIC_COMP_SSP
, SMP_AMT_RECOVERED_CALC
, SAP_AMT_RECOVERED_CALC
, OSPP_AMT_RECOVERED_CALC
, ASPP_AMT_RECOVERED_CALC
, SSP_AMT_RECOVERED_CALC
, NIC_COMP_SMP_CALC
, NIC_COMP_SAP_CALC
, NIC_COMP_OSPP_CALC
, NIC_COMP_ASPP_CALC
, NIC_COMP_SSP_CALC
, CIS_DEDUCTIONS_STUFF
, NIC_HOLIDAY_VAL
, ADV_FROM_HMRC
, CREATED_DATE
, LAST_UPDATED_DATE
, STATUS
, USER_ID
, APPROVER_ID
, OBJECT_VERSION_NUMBER
, BUSINESS_GROUP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DATE_SCHEME_CEASED
, NO_PAYMENT_DATE_FROM
, NO_PAYMENT_DATE_TO
, PERIOD_OF_INACTIVITY_FROM
, PERIOD_OF_INACTIVITY_TO
FROM HR.PAY_GB_EPS_DETAILS#;
|
|
|