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


VIEW: APPS.IGS_PS_FAC_WL_V

Object Details
Object Name: IGS_PS_FAC_WL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PS_FAC_WL_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
ROW_ID ROWID (10)
Row_id
FAC_WL_ID NUMBER (15) Yes Sequence Generated primary key
PERSON_ID NUMBER (15) Yes Person id of the faculty
PERSON_NUMBER VARCHAR2 (30) Yes Person number of the faculty
API_PERSON_ID VARCHAR2 (0)
No longer used
FULL_NAME VARCHAR2 (450)
Person full name
SEX_MEANING VARCHAR2 (80)
Sex meaning
BIRTH_DT DATE

Person birth date
CALENDAR_CAT VARCHAR2 (30) Yes Calender category at which the workload is set for a faculty. permissible values are term and academic calender categories
CALENDAR_CAT_MEANING VARCHAR2 (80) Yes Calender category meaning
CAL_TYPE VARCHAR2 (10) Yes Calender Type for which the workload is set for the faculty
CI_SEQUENCE_NUMBER NUMBER (6) Yes Sequence number for the calender instance for which the workload is set for the faculty
ALTERNATE_CODE VARCHAR2 (10)
Alternate code
STD_EXP_WL VARCHAR2 (0)
No Longer Used
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flex field
ATTRIBUTE1 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE2 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE3 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE4 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE5 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE6 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE7 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE8 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE9 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE10 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE11 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE12 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE13 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE14 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE15 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE16 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE17 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE18 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE19 VARCHAR2 (150)
Attribute flex field
ATTRIBUTE20 VARCHAR2 (150)
Attribute flex field
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT ROW_ID
,      FAC_WL_ID
,      PERSON_ID
,      PERSON_NUMBER
,      API_PERSON_ID
,      FULL_NAME
,      SEX_MEANING
,      BIRTH_DT
,      CALENDAR_CAT
,      CALENDAR_CAT_MEANING
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ALTERNATE_CODE
,      STD_EXP_WL
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_FAC_WL_V;

Dependencies

[top of page]

APPS.IGS_PS_FAC_WL_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
ViewIGS_CA_INST
ViewIGS_LOOKUP_VALUES
ViewIGS_PE_PERSON_BASE_V
SynonymIGS_PS_FAC_WL

APPS.IGS_PS_FAC_WL_V is not referenced by any database object