| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 5 |
CREW_CODE_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Prompt Table:
EN_CREW
|
| 6 |
CREW_CODE_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
04/20/2000 SPL Changed short name to "TO" for iClient simplification.
Prompt Table:
EN_CREW
|
| 7 |
CREW_RANGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=All Crews
N=No Crews
R=Crew Range
Default Value: A
|
| 8 |
DIS_WC_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Dispatch List From WorkCenter
Prompt Table:
EN_WORK_CENTER
|
| 9 |
DIS_WC_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Dispatch List To WorkCenter
Prompt Table:
EN_WORK_CENTER
|
| 10 |
MACHINE_CODE_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Prompt Table:
EN_MACHINE
|
| 11 |
MACHINE_CODE_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
04/20/2000 SPL Changed short name to "TO" for iClient simplification.
Prompt Table:
EN_MACHINE
|
| 12 |
MACHINE_RANGE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=All Mach.
N=No Machine
R=Range
Default Value: A
|
| 13 |
RES_PRINT_PRODUCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 14 |
RES_PRINT_ROUTINGS |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
RES_PRINT_TASKS |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 16 |
RES_PRINT_USE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=Print All Usages
N=Print No Resource Usages
S=Print Selected Usages:
Default Value: A
|
| 17 |
RES_PRINT_WORK_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Y/N Table Edit
Default Value: N
|
| 18 |
SEL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Selection
A=All Status
R=Range Stat
Default Value: A
|
| 19 |
TASK_CODE_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Tasks From
Default Value: EN_TASKS.TASK_CODE
Prompt Table:
EN_TASKS
|
| 20 |
TASK_CODE_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Target Task Code
Default Value: EN_TASKS.TASK_CODE
Prompt Table:
EN_TASKS
|
| 21 |
TOOL_CODE_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
Prompt Table:
EN_TOOL
|
| 22 |
TOOL_CODE_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
04/20/2000 SPL Changed short name to "TO" for iClient simplification.
Prompt Table:
EN_TOOL
|
| 23 |
TOOL_RANGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
02/26/99 SPL CN# EN800-11.0 This is a new field created for the Resources Where Used Report.
A=All Tools
N=No Tools
R=Tool Range
Default Value: A
|