[Home] [Help] [Dependency Information]
Object Name: | PAY_SECURITY_PAYROLLS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_SECURITY_PAYROLLS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
PAY_SECURITY_PAYROLLS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SECURITY_PROFILE_ID |
PAY_SECURITY_PAYROLLS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYROLL_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_SECURITY_PAYROLLS | HR_ALL_ORGANIZATION_UNITS | PAY_SECURITY_PAYROLLS BUSINESS_GROUP_ID | PAY_SECURITY_PAYROLLS | PER_SECURITY_PROFILES | PAY_SECURITY_PAYROLLS SECURITY_PROFILE_ID |
---|
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. |
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;
HR.PAY_SECURITY_PAYROLLS does not reference any database object
HR.PAY_SECURITY_PAYROLLS is referenced by following:
|
|
|