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

TABLE: HR.PER_ANALYSIS_CRITERIA

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


PER_ANALYSIS_CRITERIA is a key flexfield combinations table for the
personal analysis flexfield. This flexfield holds the segment
information for job and position requirements and person special
information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_ANALYSIS_CRITERIA_PK
  1. ColumnANALYSIS_CRITERIA_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_ANALYSIS_CRITERIA_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnANALYSIS_CRITERIA_ID
PER_ANALYSIS_CRITERIA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnID_FLEX_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePER_JOB_REQUIREMENTS PER_JOB_REQUIREMENTS_FK2 PER_ANALYSIS_CRITERIA PER_JOB_REQUIREMENTS ANALYSIS_CRITERIA_ID
TablePER_MM_JOB_REQUIREMENTS PER_MM_JOB_REQUIREMENTS_FK2 PER_ANALYSIS_CRITERIA PER_MM_JOB_REQUIREMENTS NEW_ANALYSIS_CRITERIA_ID
TablePER_MM_JOB_REQUIREMENTS PER_MM_JOB_REQUIREMENTS_FK3 PER_ANALYSIS_CRITERIA PER_MM_JOB_REQUIREMENTS ANALYSIS_CRITERIA_ID
TablePER_PERSON_ANALYSES PER_PERSON_ANALYSES_FK2 PER_ANALYSIS_CRITERIA PER_PERSON_ANALYSES ANALYSIS_CRITERIA_ID
TablePQH_TXN_JOB_REQUIREMENTS PQH_TXN_JOB_REQUIREMENTS_FK4 PER_ANALYSIS_CRITERIA PQH_TXN_JOB_REQUIREMENTS ANALYSIS_CRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_CRITERIA_ID NUMBER (15) Yes System-generated primary key column.
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.
ID_FLEX_NUM NUMBER (15) Yes Key flexfield structure foreign key.
SUMMARY_FLAG VARCHAR2 (1) Yes Key flexfield summary flag.
ENABLED_FLAG VARCHAR2 (1) Yes Key flexfield enabled flag.
START_DATE_ACTIVE DATE

Date before which key flexfield combination is invalid.
END_DATE_ACTIVE DATE

Date after which key flexfield combination is invalid.
SEGMENT1 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT2 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT3 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT4 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT5 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT6 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT7 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT8 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT9 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT10 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT11 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT12 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT13 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT14 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT15 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT16 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT17 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT18 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT19 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT20 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT21 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (150)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (150)
Key flexfield segment 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.
OBJECT_VERSION_NUMBER NUMBER (9)
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 ANALYSIS_CRITERIA_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.PER_ANALYSIS_CRITERIA;

Dependencies

[top of page]

HR.PER_ANALYSIS_CRITERIA does not reference any database object

HR.PER_ANALYSIS_CRITERIA is referenced by following:

SchemaHR
ViewPER_ANALYSIS_CRITERIA#