| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 4 |
RPT_DEST |
Character(50) |
VARCHAR2(50) NOT NULL |
File Destination
|
| 5 |
PROCESS_BEGIN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Begin Process Instance
|
| 6 |
PROCESS_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
End Process Instance
|
| 7 |
PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
PROCESS_VW
|
| 8 |
JOBID |
Character(10) |
VARCHAR2(10) NOT NULL |
Job ID
Prompt Table:
MESSAGE_LOG
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 10 |
PICK_BATCH_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Pick Batch ID
|
| 11 |
PICK_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pick Id Options
A=All
S=Single
|
| 12 |
CREATE_MFG_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
3/23/98 rlk - Change rftlong to work with RUN_MGS3000 panel
Y/N Table Edit
Default Value: Y
|
| 13 |
CREATE_WKC_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Work Center Calendars
Y/N Table Edit
Default Value: Y
|
| 14 |
CREATE_ALT_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Alternate Calendar
Y/N Table Edit
Default Value: Y
|
| 15 |
WORK_CENTER_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Workcenter Range Option
A=All
N=None
R=Range
Default Value: A
|
| 16 |
WORK_CENTER_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Center From
Prompt Table:
EN_WORK_CENTER
|
| 17 |
WORK_CENTER_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Workcenter To
Prompt Table:
EN_WORK_CENTER
|
| 18 |
CALENDAR_CODE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Calendar Code Range Option
A=All
N=None
R=Range
Default Value: A
|
| 19 |
CALENDAR_CODE_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Code From
Prompt Table:
MG_CAL_CODE_VW
|
| 20 |
CALENDAR_CODE_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Code To
Prompt Table:
MG_CAL_CODE_VW
|
| 21 |
PRINT_PROD_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Production Calendar
Y/N Table Edit
Default Value: Y
|
| 22 |
PRINT_ALT_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Alternate Calendars
Y/N Table Edit
Default Value: Y
|
| 23 |
PRINT_ALT_CAL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Alternate Calendar Codes
A=All
C=Calendar Code
N=None
Default Value: A
|
| 24 |
CALENDAR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts.
Prompt Table:
MG_CAL_CODE_VW
|
| 25 |
PRINT_ALT_CAL_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Calendar Year Option
A=All Calendar Years
N=None
Y=Calendar Year
Default Value: A
|
| 26 |
YEAR_PRINT_ALT |
Number(4,0) |
SMALLINT NOT NULL |
Print Year
Prompt Table:
%EDITTABLE
|
| 27 |
PRINT_PRD_CAL_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Calendar Years
A=All Calendar Years
N=None
Y=Calendar Year
Default Value: A
|
| 28 |
YEAR_PRINT_PRD |
Number(4,0) |
SMALLINT NOT NULL |
Print Year
Prompt Table:
MG_CALENDAR_VW2
|