DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.GHR_PAYROLL_OFFICE_NUMBER

Object Details
Object Name: GHR_PAYROLL_OFFICE_NUMBER
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


Contains information related to Payroll Office Number


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GHR_PAYROLL_OFFICE_NUMBER_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_OFFICE_NUMBER
Columns
Name Datatype Length Mandatory Comments
PAYROLL_OFFICE_NUMBER VARCHAR2 (15) Yes Payroll Office Number
PAYROLL_OFFICE_NAME VARCHAR2 (150) Yes Payroll Office Name
PAYROLL_OFFICE_ADD1 VARCHAR2 (240)
Payroll Office Address1
PAYROLL_OFFICE_ADD2 VARCHAR2 (240)
Payroll Office Address2
PAYROLL_OFFICE_ADD3 VARCHAR2 (240)
Payroll Office Address3
PAYROLL_OFFICE_ADD4 VARCHAR2 (240)
Payroll Office Address4
PAYROLL_OFF_BEN_CONT_NAME VARCHAR2 (150) Yes Payroll Office Benefits Contact Name
CONTACT_PHONE VARCHAR2 (60) Yes Contact Phone
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYROLL_OFFICE_NUMBER
,      PAYROLL_OFFICE_NAME
,      PAYROLL_OFFICE_ADD1
,      PAYROLL_OFFICE_ADD2
,      PAYROLL_OFFICE_ADD3
,      PAYROLL_OFFICE_ADD4
,      PAYROLL_OFF_BEN_CONT_NAME
,      CONTACT_PHONE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM HR.GHR_PAYROLL_OFFICE_NUMBER;

Dependencies

[top of page]

HR.GHR_PAYROLL_OFFICE_NUMBER does not reference any database object

HR.GHR_PAYROLL_OFFICE_NUMBER is referenced by following:

SchemaAPPS
SynonymGHR_PAYROLL_OFFICE_NUMBER
TriggerGHR_PAYROLL_OFFICE_NUMBER_WHO