BUDGET_IDBUDGET_START_DTWCS_GRID_TYPEIN=Worker Detail
SA=Salary Grid
VC=Awards Grid
FIELDNAMEY/N Table Edit
Default Value: N
Prompt Table: WCS_ECM_TEXT_VW
WCS_ECM_CYC_MSS(SQL Table) |
Index Back |
|---|---|
MSS Grid Display ConfigRecord used to store the Salary Grid display settings. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 2 | BUDGET_START_DT |
Date(10) | DATE NOT NULL | Budget Start Date |
| 3 | WCS_GRID_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Determines the Grid/Plan Type for the Grid Configuration
IN=Worker Detail SA=Salary Grid VC=Awards Grid |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | LABEL_ID | Character(18) | VARCHAR2(18) NOT NULL | LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. |
| 6 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Required Flag |
| 7 | SELECTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selected Flag
Y/N Table Edit Default Value: N |
| 8 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Text ID
Prompt Table: WCS_ECM_TEXT_VW |
| 9 | SORT_ORDER_NUM | Number(3,0) | SMALLINT NOT NULL | Sort Order Number |