[Home] [Help] [Dependency Information]
Object Name: | PAY_GB_YEAR_END_PAYROLLS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYROLL_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | ||
ECON | VARCHAR2 | (9) | ||
EMPLOYERS_ADDRESS_LINE | VARCHAR2 | (60) | ||
EMPLOYERS_NAME | VARCHAR2 | (36) | ||
END_PREVIOUS_YEAR | DATE | |||
END_YEAR | DATE | |||
MAX_PERIOD_NUMBER | NUMBER | (2) | ||
PAYROLL_NAME | VARCHAR2 | (80) | ||
PERIOD_TYPE | VARCHAR2 | (30) | ||
PERMIT_NUMBER | VARCHAR2 | (12) | ||
SMP_COMPENSATION | NUMBER | (10) | ||
SMP_RECOVERED | NUMBER | (10) | ||
SSP_RECOVERED | NUMBER | (10) | ||
START_PREVIOUS_YEAR | DATE | |||
START_YEAR | DATE | |||
TAX_DISTRICT_NAME | VARCHAR2 | (40) | ||
TAX_DISTRICT_REFERENCE | NUMBER | (3) | ||
TAX_REFERENCE_NUMBER | VARCHAR2 | (7) | ||
TAX_YEAR | NUMBER | (4) |
Cut, paste (and edit) the following text to query this object:
SELECT PAYROLL_ID
, BUSINESS_GROUP_ID
, ECON
, EMPLOYERS_ADDRESS_LINE
, EMPLOYERS_NAME
, END_PREVIOUS_YEAR
, END_YEAR
, MAX_PERIOD_NUMBER
, PAYROLL_NAME
, PERIOD_TYPE
, PERMIT_NUMBER
, SMP_COMPENSATION
, SMP_RECOVERED
, SSP_RECOVERED
, START_PREVIOUS_YEAR
, START_YEAR
, TAX_DISTRICT_NAME
, TAX_DISTRICT_REFERENCE
, TAX_REFERENCE_NUMBER
, TAX_YEAR
FROM HR.PAY_GB_YEAR_END_PAYROLLS#;
|
|
|