| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BUMGOP_NONVW
|
| 2 |
Z1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Table Edit
|
| 3 |
Z2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Table Edit
|
| 4 |
Z3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Table Edit
|
| 5 |
Z4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Table Edit
|
| 6 |
Z5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Table Edit
|
| 7 |
Z6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Table Edit
|
| 8 |
Z7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N Table Edit
|
| 9 |
SA1 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 10 |
SA2 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 11 |
SA3 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 12 |
SA4 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 13 |
SA5 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 14 |
SA6 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 15 |
SA7 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 16 |
SB1 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 17 |
SB2 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 18 |
SB3 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 19 |
SB4 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 20 |
SB5 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 21 |
SB6 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 22 |
SB7 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 23 |
SC1 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 24 |
SC2 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 25 |
SC3 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 26 |
SC4 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 27 |
SC5 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 28 |
SC6 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|
| 29 |
SC7 |
Number(2,0) |
SMALLINT NOT NULL |
Prompt Table:
MG_SHIFTS_VW
|