| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
MU_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Mass Update ID
|
| 6 |
MU_REFERENCE_DT |
Date(10) |
DATE |
Mass Update process applies changes on effective dated row according to the date given reference date.
|
| 7 |
MU_PRCS_MODE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Update Process updates or adds values according to this flag.
I=Add a New Effective Date
U=Correct Current Information
|
| 8 |
MU_FUTURE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Eligible Future Rows
Y/N Table Edit
|
| 9 |
MU_CHG_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Change Number
|
| 10 |
MU_SELECTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection type: Mass Update process generates the employee list on which occurs changes. This list can be generated by department, group, etc.
A=Active Employee
B=Business Unit
C=Company
D=Department
E=Establishment
F=Job Effective Date
G=Group Build
I=Assignment Departure
J=Job Code
L=Location
M=Labor Agreement
N=Job Assignment End
P=Position Number
R=Rank
S=Job Assignment Start
T=Organizational Relationship
U=Union Code
V=Assignment Arrival
Y=Labor Facility
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 12 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 13 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
|
| 14 |
MILITARY_SERVICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Military Service
|
| 15 |
MU_VALUE_CHAR |
Character(254) |
VARCHAR2(254) NOT NULL |
Character Value
|
| 16 |
MU_VALUE_DT |
Date(10) |
DATE |
Date Value
|
| 17 |
MU_VALUE_NUM |
Number(22,6) |
DECIMAL(21,6) NOT NULL |
Numeric Value
|
| 18 |
MU_VALUE_BOOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Boolean Value
|
| 19 |
MU_VALUE_FROM_DT |
Date(10) |
DATE |
From Date
|
| 20 |
MU_VALUE_TO_DT |
Date(10) |
DATE |
To Date
|
| 21 |
MU_PRCS_POP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process
E=Exclude
I=Include
|
| 22 |
MU_COPY_FWD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Forward
Y/N Table Edit
|
| 23 |
MU_SECTION |
Character(20) |
VARCHAR2(20) NOT NULL |
Section
|
| 24 |
MU_ELEMENT |
Character(20) |
VARCHAR2(20) NOT NULL |
Element
|
| 25 |
MU_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction ID
|
| 26 |
MU_LEVEL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Level
E=Employee Record
P=Person
|
| 27 |
MU_PARALLEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Parallel Processing
Y/N Table Edit
|
| 28 |
MU_MAX_INSTANCES |
Number(3,0) |
SMALLINT NOT NULL |
Maximum of Instances
|
| 29 |
MU_TRS_INSTANCES |
Number(5,0) |
INTEGER NOT NULL |
Transactions per Instance
|
| 30 |
MU_COMMIT_LVL |
Number(5,0) |
INTEGER NOT NULL |
Commit Interval
|
| 31 |
MU_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Mass Update Instance
|
| 32 |
MU_PROMPT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Prompt
A=Action
C=Checkbox
D=Date
N=Numeric
R=Record
T=Translate
|
| 33 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 34 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 35 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 36 |
MU_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID used for Mass Update
|
| 37 |
YES |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes
|
| 38 |
MU_EXEC_STATUS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mass Update execution result status flag.
C=Cancel
F=Failure
R=Ready
S=Success
W=Warning
|
| 39 |
SQL_STMT |
Long Character(8048) |
CLOB |
SQL Statement
|