SCC_SRV_IN_RSNF(SQL Table) |
Index Back |
|---|---|
Serv indicator rsn fluid optCreated to add fluid options to Service indicator reason |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
|
| 2 | Character(3) | VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table: SRVC_IND_CD_TBL |
|
| 3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
| 4 | Character(5) | VARCHAR2(5) NOT NULL | Service Indicator Reason | |
| 5 | SCC_DISP_ST_TERM | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of start term on fluid page
Y/N Table Edit |
| 6 | SCC_DISP_END_TERM | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of end term on fluid page
Y/N Table Edit |
| 7 | SCC_DISP_ST_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of start date on fluid page
Y/N Table Edit |
| 8 | SCC_DISP_END_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of End Date on fluid page
Y/N Table Edit |
| 9 | SCC_DISP_DEPT | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of department on fluid page
Y/N Table Edit |
| 10 | SCC_DISP_AMOUNT | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of amount on fluid page
Y/N Table Edit |
| 11 | SCC_DISP_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of contact name on fluid page
Y/N Table Edit |
| 12 | SCC_DISP_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of email on fluid page
Y/N Table Edit |
| 13 | SCC_ACTN_BTN_LBL | Character(40) | VARCHAR2(40) NOT NULL | Field to enable display of department on fluid page |
| 14 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUNAME_VW |
| 15 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSMENUCOMP_VW |
| 16 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: SSR_COMP_PNL_VW |