SSF_SL_INST(SQL Table) |
Index Back |
|---|---|
StudyLink Institution Defaults |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | SSF_PERIOD_BUF | Number(3,0) | SMALLINT NOT NULL | Period Offset Days |
| 5 | SSF_VACATION_BUF | Number(3,0) | SMALLINT NOT NULL | Defines the number of days that comprise a vacation. |
| 6 | SSF_LOAN_BUF | Number(3,0) | SMALLINT NOT NULL | Loan Buffer |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | SSF_HISTORY_BUF | Number(3,0) | SMALLINT NOT NULL | IVS History Buffer |
| 9 | SSF_IVS_ACTIVE_BUF | Number(3,0) | SMALLINT NOT NULL | IVS Active Buffer |
| 10 | ITEM_TERM | Character(4) | VARCHAR2(4) NOT NULL |
Item Term
Prompt Table: SF_TERM_VW2 |
| 11 | SSF_SL_FILE_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Unique system assigned number identifying a file coming from StudyLink. |
| 12 | REFUND_EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
Refund External Org ID
Prompt Table: EXT_ORG_TBL |
| 13 | REFUND_ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL |
Refund Org Contact
Prompt Table: ORG_CONT_REF_VW |
| 14 | SSF_ROUND_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Round Dates
Y/N Table Edit Default Value: Y |