[Home] [Help]
View: IGS_PR_MILESTONE_V
Product: | IGS - Student System (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PERSON_ID
, CA_SEQUENCE_NUMBER
, SEQUENCE_NUMBER
, MILESTONE_TYPE
, MILESTONE_STATUS
, DUE_DT
, DESCRIPTION
, ACTUAL_REACHED_DT
, 'N' INCLUDE_REACHED_MILESTONES
, NVL(PERSON_ID
, NULL) PRECED_PERSON_ID
, NVL(CA_SEQUENCE_NUMBER
, NULL) PRECED_CA_SEQUENCE_NUMBER
, PRECED_SEQUENCE_NUMBER
, OVRD_NTFCTN_IMMINENT_DAYS
, OVRD_NTFCTN_REMINDER_DAYS
, OVRD_NTFCTN_RE_REMINDER_DAYS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, COMMENTS
FROM IGS_PR_MILESTONE MIL
Columns
Name |
PERSON_ID |
CA_SEQUENCE_NUMBER |
SEQUENCE_NUMBER |
MILESTONE_TYPE |
MILESTONE_STATUS |
DUE_DT |
DESCRIPTION |
ACTUAL_REACHED_DT |
INCLUDE_REACHED_MILESTONES |
PRECED_PERSON_ID |
PRECED_CA_SEQUENCE_NUMBER |
PRECED_SEQUENCE_NUMBER |
OVRD_NTFCTN_IMMINENT_DAYS |
OVRD_NTFCTN_REMINDER_DAYS |
OVRD_NTFCTN_RE_REMINDER_DAYS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
COMMENTS |