FO_MC_USR_TYPER=Mass Change - Assignment Rates
Prompt Table: FO_SC_CFG_HDR
Prompt Table: RECDEFN_VW
Prompt Table: RECDEFN_VW
FO_MC_TYPE_TBL(SQL Table) |
Index Back |
|---|---|
Mass Change Type Setup.Defines Mass Change Types. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_MC_USR_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | User Mass Change Type |
| 2 | FO_MC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Mass Change Types:
R: Assignment Rates
R=Mass Change - Assignment Rates |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | FO_SRCH_CRIT_ID | Character(30) | VARCHAR2(30) NOT NULL |
Mass Change Search Criteria ID
Prompt Table: FO_SC_CFG_HDR |
| 5 | FO_SC_SRCH_RES_REC | Character(15) | VARCHAR2(15) NOT NULL |
Determines the Record to be used as Srch Results.
Used in Staffing Search Criteria.
Prompt Table: RECDEFN_VW |
| 6 | FO_SC_SRCH_SEL_ITM | Character(15) | VARCHAR2(15) NOT NULL |
Determines the Record to be used as Selected Items.
Used in Staffing Search Criteria.
Prompt Table: RECDEFN_VW |