| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 MU_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Mass Update ID
|
| 2 |
MU_CHG_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Change Number
|
| 3 |
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
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_HR
|
| 5 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table:
REG_STANDARD_VW
|
| 6 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
HR_LABOR_AGRMNT
|
| 7 |
MILITARY_SERVICE |
Character(8) |
VARCHAR2(8) NOT NULL |
Military Service
Prompt Table:
MIL_SERVICE_TBL
|
| 8 |
MU_VALUE_CHAR |
Character(254) |
VARCHAR2(254) NOT NULL |
Character Value
Prompt Table:
%EDITTABLE
|
| 9 |
MU_VALUE_FROM_DT |
Date(10) |
DATE |
From Date
|
| 10 |
MU_VALUE_TO_DT |
Date(10) |
DATE |
To Date
|
| 11 |
MU_VALUE_BOOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Boolean Value
Y/N Table Edit
Default Value: N
|
| 12 |
MU_PRCS_POP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process
E=Exclude
I=Include
Default Value: I
|
| 13 |
DATA_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
|