[Home] [Help]
[Dependency Information]
Object Name: | IGS_UC_IVSTARZ1_2003_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, application clearing information will be held in different Hercules views for different systems. This View selects the application clearing information belonging to all the systems.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPNO | NUMBER | (22) | Application Number | |
TIMESTAMP | DATE | Time stamp - date and time of last change | ||
DATECEFSENT | DATE | Date Clearing Entry Form sent | ||
CEFNO | NUMBER | (22) | Clearing Entry Form Number | |
CENTRALCLEARING | VARCHAR2 | (1) | Central Clearing was discontinued in 1999. This field is no longer used, but contains the constant "N" for backward compatibility. | |
INST | VARCHAR2 | (3) | Institution Code | |
COURSE | VARCHAR2 | (6) | Course Code | |
CAMPUS | VARCHAR2 | (1) | Campus Code | |
FACULTY | VARCHAR2 | (1) | Faculty Code | |
ENTRYYEAR | NUMBER | (22) | Entry Year | |
ENTRYMONTH | NUMBER | (22) | Entry Month | |
ENTRYPOINT | VARCHAR2 | (1) | Point of Entry | |
RESULT | VARCHAR2 | (1) | Result. Previously used in Central Clearing. Now only contains "A" (Accept) if Inst or Course are not null. Null otherwise |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, DATECEFSENT
, CEFNO
, CENTRALCLEARING
, INST
, COURSE
, CAMPUS
, FACULTY
, ENTRYYEAR
, ENTRYMONTH
, ENTRYPOINT
, RESULT
FROM APPS.IGS_UC_IVSTARZ1_2003_V;
|
|
|