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

VIEW: APPS.HRBV_SUBJECTS_TAKEN_V

Object Details
Object Name: HRBV_SUBJECTS_TAKEN_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Subjects takens (from PER_SUBJECTS_TAKEN/TL table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
START_DATE DATE
Yes Start date.
MAJOR VARCHAR2 (30)
(Lookup code based on lookup type YES_NO).
MAJOR_M VARCHAR2 (4000)
(Lookup meaning based on lookup type YES_NO).
SUBJECT_STATUS VARCHAR2 (30) Yes (Lookup code based on lookup type PER_SUBJECT_STATUSES).
SUBJECT_STATUS_M VARCHAR2 (4000)
(Lookup meaning based on lookup type PER_SUBJECT_STATUSES).
SUBJECT VARCHAR2 (30) Yes (Lookup code based on lookup type PER_SUBJECTS).
SUBJECT_M VARCHAR2 (4000)
(Lookup meaning based on lookup type PER_SUBJECTS).
GRADE_ATTAINED VARCHAR2 (100)
Grade.
END_DATE DATE

End date.
SUB_INFORMATION_CATEGORY VARCHAR2 (30)
Sub information category.
SUB_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
SUB_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
_DF:SUB CHAR (30)
SUBJECTS_TAKEN_ID NUMBER (9) Yes Primary key for PER_SUBJECTS_TAKEN.
QUALIFICATION_ID NUMBER (9) Yes Foreign key to PER_QUALIFICATIONS.
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
Query Text

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


SELECT START_DATE
,      MAJOR
,      MAJOR_M
,      SUBJECT_STATUS
,      SUBJECT_STATUS_M
,      SUBJECT
,      SUBJECT_M
,      GRADE_ATTAINED
,      END_DATE
,      SUB_INFORMATION_CATEGORY
,      SUB_INFORMATION1
,      SUB_INFORMATION2
,      SUB_INFORMATION3
,      SUB_INFORMATION4
,      SUB_INFORMATION5
,      SUB_INFORMATION6
,      SUB_INFORMATION7
,      SUB_INFORMATION8
,      SUB_INFORMATION9
,      SUB_INFORMATION10
,      SUB_INFORMATION11
,      SUB_INFORMATION12
,      SUB_INFORMATION13
,      SUB_INFORMATION14
,      SUB_INFORMATION15
,      SUB_INFORMATION16
,      SUB_INFORMATION17
,      SUB_INFORMATION18
,      SUB_INFORMATION19
,      SUB_INFORMATION20
,      _DF:SUB
,      SUBJECTS_TAKEN_ID
,      QUALIFICATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.HRBV_SUBJECTS_TAKEN_V;

Dependencies

[top of page]

APPS.HRBV_SUBJECTS_TAKEN_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymPER_SUBJECTS_TAKEN

APPS.HRBV_SUBJECTS_TAKEN_V is not referenced by any database object