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


TABLE: HR.PER_SPINAL_POINT_PLACEMENTS_F

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


PER_SPINAL_POINT_PLACEMENTS_F stores details of assignment placements
to a grade step and point. The AUTO_INCREMENT_FLAG can be set to N if
you do not want the grade step placement to be changed by the batch
increment process. PER_SPINAL_POINT_PLACEMENTS_F is a DateTracked
table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_SPINAL_POINT_PLACEMENT_PK
  1. ColumnPLACEMENT_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
PER_SPINAL_POINT_PLACEMENT_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLACEMENT_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PER_SPINAL_POINT_PLACEMENT_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_SPINAL_POINT_PLACEMENT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
PER_SPINAL_POINT_PLACEMENT_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTEP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_SPINAL_POINT_PLACEMENTS_F PER_SPINAL_POINT_PLACEMENT_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_SPINAL_POINT_PLACEMENTS_F BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
PLACEMENT_ID NUMBER (15) Yes System-generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
ASSIGNMENT_ID NUMBER (10) Yes Foreign key to PER_ALL_ASSIGNMENTS_F.
STEP_ID NUMBER (15) Yes Foreign key to PER_SPINAL_POINT_STEPS.
AUTO_INCREMENT_FLAG VARCHAR2 (30) Yes Indicates whether the default batch process should update this placement automatically.
PARENT_SPINE_ID NUMBER (15) Yes Foreign key to PER_PARENT_SPINES.
REASON VARCHAR2 (30)
Reason for placing the assignment on this point.
REQUEST_ID NUMBER (15)
Standard Who Column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who Column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
INCREMENT_NUMBER NUMBER

Number to incrment by in auto increment process.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION21 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION22 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION23 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION24 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION25 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION26 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION27 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION28 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION29 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION30 VARCHAR2 (150)
Developer Descriptive Flexfield
INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flexfield
Query Text

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


SELECT PLACEMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      ASSIGNMENT_ID
,      STEP_ID
,      AUTO_INCREMENT_FLAG
,      PARENT_SPINE_ID
,      REASON
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      INCREMENT_NUMBER
,      OBJECT_VERSION_NUMBER
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      INFORMATION_CATEGORY
FROM HR.PER_SPINAL_POINT_PLACEMENTS_F;

Dependencies

[top of page]

HR.PER_SPINAL_POINT_PLACEMENTS_F does not reference any database object

HR.PER_SPINAL_POINT_PLACEMENTS_F is referenced by following:

SchemaAPPS
TriggerPERSPINALPOINTPLACEMEN_58U_DYT
TriggerPERSPINALPOINTPLACEM_2132D_DYT
SynonymPER_SPINAL_POINT_PLACEMENTS_F
TriggerPER_SPINAL_POINT_PLACEMENT_WHO
SchemaPUBLIC
SynonymPER_SPINAL_POINT_PLACEMENTS_F