EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
STRMPrompt Table: SSR_VB_TERM_VW
SSR_VB_SEQUENCESSR_VB_BEN_TYPEFED=Federal
STA=State
I=In Review
R=Reported
A=Use Actual
E=Use Equation
R=Use Rate Per Unit
SSR_VB_TUI_WRKS(SQL Table) |
Index Back |
|---|---|
Tuition Worksheet |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 3 | STRM |
Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: SSR_VB_TERM_VW |
| 4 | SSR_VB_SEQUENCE |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | SSR_VB_BEN_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Benefit Type
FED=Federal STA=State |
| 6 | SSR_VB_ENR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Term Enrollment Status
I=In Review R=Reported |
| 7 | SSR_VB_ANT_PAYMENT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Anticipated Payment |
| 8 | SSR_VB_CALC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Method
A=Use Actual E=Use Equation R=Use Rate Per Unit |
| 9 | SSR_VB_RATE | Number(8,2) | DECIMAL(7,2) NOT NULL | Rate Per Unit |
| 10 | SSR_VB_IN_STA_TUI | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | In State Tuition and Fees (B) |
| 11 | SSR_VB_OUT_STA_TUI | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Out of State Tuition and Fees |
| 12 | SSR_VB_PREDET_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | Pre-determined Amount |
| 13 | SSR_VB_EQUATION | Character(12) | VARCHAR2(12) NOT NULL | Tuition and Fees Equation |
| 14 | SSR_VB_UPDATE_STA | Date(10) | DATE | Last Updated |
| 15 | SSR_VB_UPDBY_STA | Character(30) | VARCHAR2(30) NOT NULL | Updated By |