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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | SRVC_IND_CD | Character(3) | VARCHAR2(3) NOT NULL |
Service Indicator Cd
Prompt Table: SRVC_IND_CD_TBL |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | SRVC_IND_REASON | 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 |