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


TABLE: HR.PER_SEC_PROFILE_ASSIGNMENTS

Object Details
Object Name: PER_SEC_PROFILE_ASSIGNMENTS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_SEC_PROFILE_ASSIGNMENTS
Subobject Name:
Status: VALID


PER_SEC_PROFILE_ASSIGNMENTS holds definitions of a security profile
assignments to a user, responsibility and business group.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_SEC_PROFILE_ASSIGNMENTS_PK
  1. ColumnSEC_PROFILE_ASSIGNMENT_ID
Unique Key: PER_SEC_PROFILE_ASSIGNMENTS_UK
  1. ColumnUSER_ID
  2. ColumnRESPONSIBILITY_ID
  3. ColumnRESPONSIBILITY_APPLICATION_ID
  4. ColumnSECURITY_GROUP_ID
  5. ColumnBUSINESS_GROUP_ID
  6. ColumnSECURITY_PROFILE_ID
  7. ColumnSTART_DATE
  8. ColumnEND_DATE
Indexes
Index Type Uniqueness Tablespace Column
PER_SEC_PROFILE_ASSIGNMENTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEC_PROFILE_ASSIGNMENT_ID
PER_SEC_PROFILE_ASSIGNMENTS_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
ColumnRESPONSIBILITY_ID
ColumnRESPONSIBILITY_APPLICATION_ID
ColumnSECURITY_GROUP_ID
ColumnBUSINESS_GROUP_ID
ColumnSECURITY_PROFILE_ID
ColumnSTART_DATE
ColumnEND_DATE
PER_SEC_PROFILE_ASSIGNMENTS_FK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSECURITY_PROFILE_ID
PER_SEC_PROFILE_ASSIGNMENT_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SEC_PROFILE_ASSIGNMENTS PER_SEC_PROFILE_ASSIGNMENT_FK2 TableHR_ALL_ORGANIZATION_UNITS PER_SEC_PROFILE_ASSIGNMENTS BUSINESS_GROUP_ID
PER_SEC_PROFILE_ASSIGNMENTS PER_SEC_PROFILE_ASSIGNMENTS_FK TablePER_SECURITY_PROFILES PER_SEC_PROFILE_ASSIGNMENTS SECURITY_PROFILE_ID
Columns
Name Datatype Length Mandatory Comments
SEC_PROFILE_ASSIGNMENT_ID NUMBER (15) Yes System-generated primary key column.
USER_ID NUMBER (15) Yes Foreign key to FND_USER.
SECURITY_GROUP_ID NUMBER (15) Yes Foreign key to FND_SECURITY_GROUPS.
SECURITY_PROFILE_ID NUMBER (15) Yes Foreign key to PER_SECURITY_PROFILES.
RESPONSIBILITY_ID NUMBER (15) Yes Foreign key to FND_RESPONSIBILITY.
RESPONSIBILITY_APPLICATION_ID NUMBER (15) Yes Foreign key to FND_RESPONSIBILITY.
START_DATE DATE
Yes Start date of the security profile assignment.
END_DATE DATE

End date of the security profile assignment.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATE_LOGIN NUMBER (12)
Standard Who column.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATION_UNITS.
Query Text

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


SELECT SEC_PROFILE_ASSIGNMENT_ID
,      USER_ID
,      SECURITY_GROUP_ID
,      SECURITY_PROFILE_ID
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_APPLICATION_ID
,      START_DATE
,      END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      BUSINESS_GROUP_ID
FROM HR.PER_SEC_PROFILE_ASSIGNMENTS;

Dependencies

[top of page]

HR.PER_SEC_PROFILE_ASSIGNMENTS does not reference any database object

HR.PER_SEC_PROFILE_ASSIGNMENTS is referenced by following:

SchemaHR
ViewPER_SEC_PROFILE_ASSIGNMENTS#