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


TABLE: HR.PAY_SECURITY_PAYROLLS

Object Details
Object Name: PAY_SECURITY_PAYROLLS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_SECURITY_PAYROLLS
Subobject Name:
Status: VALID


PAY_SECURITY_PAYROLLS holds a list of payrolls accessible by specific
security profiles. The security profile specifies which payrolls can
be accessed. For each payroll specified, the security profile user
can view details of the payroll and the employees assigned to it. If
specific payrolls are excluded, the security profile user can view
details of all other payrolls in the Business Group and employees
assigned to them.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PAY_SECURITY_PAYROLLS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PAY_SECURITY_PAYROLLS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECURITY_PROFILE_ID
PAY_SECURITY_PAYROLLS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_SECURITY_PAYROLLS PAY_SECURITY_PAYROLLS_FK1 TableHR_ALL_ORGANIZATION_UNITS PAY_SECURITY_PAYROLLS BUSINESS_GROUP_ID
PAY_SECURITY_PAYROLLS PAY_SECURITY_PAYROLLS_FK2 TablePER_SECURITY_PROFILES PAY_SECURITY_PAYROLLS SECURITY_PROFILE_ID
Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group for security profile.
SECURITY_PROFILE_ID NUMBER (15) Yes Security profile restricted by payroll.
PAYROLL_ID NUMBER (9) Yes Payroll accessible by the security profile.
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (8) Yes System-generated version of row. Increments by one with each update.
Query Text

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


SELECT BUSINESS_GROUP_ID
,      SECURITY_PROFILE_ID
,      PAYROLL_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.PAY_SECURITY_PAYROLLS;

Dependencies

[top of page]

HR.PAY_SECURITY_PAYROLLS does not reference any database object

HR.PAY_SECURITY_PAYROLLS is referenced by following:

SchemaAPPS
SynonymPAY_SECURITY_PAYROLLS
TriggerPAY_SECURITY_PAYROLLS_OVN
TriggerPAY_SECURITY_PAYROLLS_WHO
SchemaPUBLIC
SynonymPAY_SECURITY_PAYROLLS