[Home] [Help] [Dependency Information]
Object Name: | PAY_GB_YEAR_END_ASSIGNMENTS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
EFFECTIVE_END_DATE | DATE | Yes | ||
PAYROLL_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_NUMBER | VARCHAR2 | (14) | ||
CHUNK_NUMBER | NUMBER | (9) | ||
DATE_OF_BIRTH | DATE | |||
DIRECTOR_INDICATOR | VARCHAR2 | (1) | ||
EFFECTIVE_START_DATE | DATE | |||
EOY_PRIMARY_FLAG | VARCHAR2 | (1) | ||
EXPENSE_CHECK_SEND_TO_ADDRESS | VARCHAR2 | (1) | ||
EXTRACT_DATE | DATE | |||
FIRST_NAME | VARCHAR2 | (16) | ||
GROSS_PAY | NUMBER | (9) | ||
LAST_ASG_ACTION_ID | NUMBER | (15) | ||
LAST_EFFECTIVE_DATE | DATE | |||
LAST_NAME | VARCHAR2 | (20) | ||
LOCATION_ID | NUMBER | (9) | ||
MIDDLE_NAME | VARCHAR2 | (7) | ||
MULTIPLE_ASG_FLAG | VARCHAR2 | (1) | ||
NATIONAL_INSURANCE_NUMBER | VARCHAR2 | (9) | ||
ORGANIZATION_ID | NUMBER | (9) | ||
PENSIONER_INDICATOR | VARCHAR2 | (1) | ||
PEOPLE_GROUP_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (10) | ||
PREVIOUS_TAXABLE_PAY | NUMBER | (9) | ||
PREVIOUS_TAX_PAID | NUMBER | (9) | ||
PREVIOUS_YEAR_ASG_ACTION_ID | NUMBER | (15) | ||
PREVIOUS_YEAR_EFFECTIVE_DATE | DATE | |||
REQUEST_ID | NUMBER | (12) | ||
SEX | VARCHAR2 | (1) | ||
SMP | NUMBER | (9) | ||
SSP | NUMBER | (9) | ||
SUPERANNUATION_PAID | NUMBER | (9) | ||
SUPERANNUATION_REFUND | VARCHAR2 | (1) | ||
TAXABLE_PAY | NUMBER | (9) | ||
TAX_CODE | VARCHAR2 | (5) | ||
TAX_PAID | NUMBER | |||
TAX_REFUND | VARCHAR2 | (1) | ||
TAX_RUN_RESULT_ID | NUMBER | (15) | ||
TERMINATION_DATE | DATE | |||
TITLE | VARCHAR2 | (30) | ||
START_OF_EMP | DATE | |||
TERMINATION_TYPE | VARCHAR2 | (1) | ||
W1_M1_INDICATOR | VARCHAR2 | (1) | ||
WEEK_53_INDICATOR | VARCHAR2 | (1) | ||
WIDOWS_AND_ORPHANS | NUMBER | (9) | ||
ADDRESS_LINE1 | VARCHAR2 | (60) | ||
ADDRESS_LINE2 | VARCHAR2 | (60) | ||
ADDRESS_LINE3 | VARCHAR2 | (60) | ||
TOWN_OR_CITY | VARCHAR2 | (30) | ||
COUNTY | VARCHAR2 | (27) | ||
POSTAL_CODE | VARCHAR2 | (8) |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, EFFECTIVE_END_DATE
, PAYROLL_ID
, ASSIGNMENT_NUMBER
, CHUNK_NUMBER
, DATE_OF_BIRTH
, DIRECTOR_INDICATOR
, EFFECTIVE_START_DATE
, EOY_PRIMARY_FLAG
, EXPENSE_CHECK_SEND_TO_ADDRESS
, EXTRACT_DATE
, FIRST_NAME
, GROSS_PAY
, LAST_ASG_ACTION_ID
, LAST_EFFECTIVE_DATE
, LAST_NAME
, LOCATION_ID
, MIDDLE_NAME
, MULTIPLE_ASG_FLAG
, NATIONAL_INSURANCE_NUMBER
, ORGANIZATION_ID
, PENSIONER_INDICATOR
, PEOPLE_GROUP_ID
, PERSON_ID
, PREVIOUS_TAXABLE_PAY
, PREVIOUS_TAX_PAID
, PREVIOUS_YEAR_ASG_ACTION_ID
, PREVIOUS_YEAR_EFFECTIVE_DATE
, REQUEST_ID
, SEX
, SMP
, SSP
, SUPERANNUATION_PAID
, SUPERANNUATION_REFUND
, TAXABLE_PAY
, TAX_CODE
, TAX_PAID
, TAX_REFUND
, TAX_RUN_RESULT_ID
, TERMINATION_DATE
, TITLE
, START_OF_EMP
, TERMINATION_TYPE
, W1_M1_INDICATOR
, WEEK_53_INDICATOR
, WIDOWS_AND_ORPHANS
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, TOWN_OR_CITY
, COUNTY
, POSTAL_CODE
FROM HR.PAY_GB_YEAR_END_ASSIGNMENTS#;
|
|
|