EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: INSTITUTION_TBL
STRMPrompt Table: SSR_VB_TERM_VW
SSR_VB_SEQUENCESSR_VB_BEN_TYPEFED=Federal
STA=State
ITEM_TYPEPrompt Table: SSR_VB_ITEMVW
ITEM_NBRLINE_SEQ_NBRDefault Value: %Date
SSR_VB_FED_W_VW(SQL View) |
Index Back |
|---|
| SELECT EMPLID , INSTITUTION , STRM , SSR_VB_SEQUENCE , SSR_VB_BEN_TYPE , ITEM_TYPE , ITEM_NBR , LINE_SEQ_NBR , CLASS_NBR , POSTED_DATE , SSR_VB_NET , SSR_VB_OVERRIDE FROM %Table(ssr_vb_tui_ovrw) WHERE ssr_vb_ben_type='FED' |
| # | 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 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: SSR_VB_ITEMVW |
| 7 | ITEM_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Item Nbr |
| 8 | LINE_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Line Sequence Nbr |
| 9 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 10 | POSTED_DATE | Date(10) | DATE |
Date Posted
Default Value: %Date |
| 11 | SSR_VB_NET | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Net Tuition and Fees |
| 12 | SSR_VB_OVERRIDE | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Override Amount |