[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_DOCPROC_STUP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_DOCPROC_STUP |
Subobject Name: | |
Status: | VALID |
Contains institutional setup of options governing general Document Request Processing
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_DOCPROC_STUP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TPSET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TPSET_ID | NUMBER | (15) | Yes | Sequence Generated Column |
LIFETIME_TRANS_FEE_IND | VARCHAR2 | (1) | Yes | Allow Life Time Transcript Fee paid Indicator |
PROVIDE_TRANSCRIPT_IND | VARCHAR2 | (1) | Yes | Indicates whether the Transcript request is allowed or not |
TRANS_REQUEST_IF_HOLD_IND | VARCHAR2 | (1) | Yes | Do not allow Transcript to be requested if Transcript Hold exists indicator DEFAULT ?N? |
ALL_ACAD_HIST_IN_ONE_DOC_IND | VARCHAR2 | (1) | Yes | Indicates whether all academic history should be included in one transcript. |
HOLD_DELIV_IND | VARCHAR2 | (1) | Yes | Allow Transcript to be requested if Transcript Hold exists but hold delivery of document until Hold clears Indicator Default ?N? |
ALLOW_ENROLL_CERT_IND | VARCHAR2 | (1) | Yes | Indicates whether the Enrollment certification is allowed or not |
BILL_ME_LATER_IND | VARCHAR2 | (1) | Yes | Bill Me later Indicator |
EDI_CAPABLE_IND | VARCHAR2 | (1) | Yes | Indicates whether the institute is capable of delivering by EDI or Not |
ALWAYS_SEND_DOCS_VIA_EDI | VARCHAR2 | (1) | Yes | Always send documents via EDI to those institutions designated EDI partners |
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 | |
PROVIDE_DUPLICATE_DOC_IND | VARCHAR2 | (1) | If not checked on setup form, all "Duplicate" processing is disabled. Default value is "N" | |
ADMINISTRATOR_ID | VARCHAR2 | (100) | User ID to whom admin notifications are to be sent | |
CHARGE_DOCUMENT_FEE_IND | VARCHAR2 | (1) | Charge Document Fee Indicator | |
CHARGE_DELIVERY_FEE_IND | VARCHAR2 | (1) | Charge Delivery Fee Indicator |
Cut, paste (and edit) the following text to query this object:
SELECT TPSET_ID
, LIFETIME_TRANS_FEE_IND
, PROVIDE_TRANSCRIPT_IND
, TRANS_REQUEST_IF_HOLD_IND
, ALL_ACAD_HIST_IN_ONE_DOC_IND
, HOLD_DELIV_IND
, ALLOW_ENROLL_CERT_IND
, BILL_ME_LATER_IND
, EDI_CAPABLE_IND
, ALWAYS_SEND_DOCS_VIA_EDI
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROVIDE_DUPLICATE_DOC_IND
, ADMINISTRATOR_ID
, CHARGE_DOCUMENT_FEE_IND
, CHARGE_DELIVERY_FEE_IND
FROM IGS.IGS_AS_DOCPROC_STUP;
IGS.IGS_AS_DOCPROC_STUP does not reference any database object
IGS.IGS_AS_DOCPROC_STUP is referenced by following:
|
|
|