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

VIEW: APPS.PER_QH_SIT_V

Object Details
Object Name: PER_QH_SIT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_QH_SIT_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ANALYSIS_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
ANALYSIS_CRITERIA_ID NUMBER (15) Yes Foreign key to PER_ANALYSIS_CRITERIA.
PERSON_ID NUMBER (10) Yes Foreign key to PER_ALL_PEOPLE_F.
DATE_FROM DATE

Start date for the personal analysis information.
DATE_TO DATE

End date for the personal analysis information.
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.
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.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield 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 PERSON_ANALYSIS_ID
,      BUSINESS_GROUP_ID
,      ANALYSIS_CRITERIA_ID
,      PERSON_ID
,      DATE_FROM
,      DATE_TO
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OBJECT_VERSION_NUMBER
FROM APPS.PER_QH_SIT_V;

Dependencies

[top of page]

APPS.PER_QH_SIT_V references the following:

SchemaAPPS
SynonymPER_ANALYSIS_CRITERIA
SynonymPER_PERSON_ANALYSES
APPS.PER_QH_SIT_V is referenced by following:

SchemaPUBLIC
SynonymPER_QH_SIT_V