SCC_CHKLSTI_FLD(SQL Table) |
Index Back |
---|---|
Checklist item fluid optionCreate to add fluid options to checklist item table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CHKLST_ITEM_CD | Character(6) | VARCHAR2(6) NOT NULL | Checklist Item Code |
2 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
3 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
4 | SCC_DISP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of status on fluid page
Y/N Table Edit |
5 | SCC_DISP_STA_DT | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of status date on fluid page
Y/N Table Edit |
6 | SCC_DISP_NAME | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of contact name on fluid page
Y/N Table Edit |
7 | SCC_DISP_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of email on fluid page
Y/N Table Edit |
8 | SCC_DISP_DUE_DT | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of contact name on fluid page
Y/N Table Edit |
9 | SCC_DISP_ORGNZTION | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of organization on fluid page
Y/N Table Edit Default Value: N |
10 | SCC_DISP_VAR_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Field to enable display of variable data on fluid page
Y/N Table Edit |
11 | SCC_ACTN_BTN_LBL | Character(40) | VARCHAR2(40) NOT NULL | Field to enable display of department on fluid page |
12 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUNAME_VW |
13 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: PSMENUCOMP_VW |
14 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: SSR_COMP_PNL_VW |