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

TABLE: IGS.IGS_PS_EMP_CATS_WL

Object Details
Object Name: IGS_PS_EMP_CATS_WL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_PS_EMP_CATS_WL
Subobject Name:
Status: VALID


This entity describes the workload for employment categories. Data will be fetch from Lookups of HR, if HR installed or else it will get the values from lookups of Student System


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PS_EMP_CATS_WL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_CAT_CODE
ColumnEMP_CAT_CODE
Columns
Name Datatype Length Mandatory Comments
CAL_CAT_CODE VARCHAR2 (30) Yes Calendar Category at which expected workload is stored at institutional level. Permission values are Term(Load) and Academic calendar categories.
EMP_CAT_CODE VARCHAR2 (30) Yes Employment category for a calendar category. Values for this field are populated from lookups either from HR (if HR is installed) or OSS (if HR is not installed).
EXPECTED_WL_NUM NUMBER (6) Yes Expected workload in the given calendar category.
CREATED_BY NUMBER (15) Yes Standard WHO columns
CREATION_DATE DATE
Yes Standard WHO columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO columns
LAST_UPDATE_DATE DATE
Yes Standard WHO columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns
Query Text

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


SELECT CAL_CAT_CODE
,      EMP_CAT_CODE
,      EXPECTED_WL_NUM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PS_EMP_CATS_WL;

Dependencies

[top of page]

IGS.IGS_PS_EMP_CATS_WL does not reference any database object

IGS.IGS_PS_EMP_CATS_WL is referenced by following:

SchemaAPPS
SynonymIGS_PS_EMP_CATS_WL