| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
This field was copied from Resource Management.
Default Value: NEXT
|
| 2 |
PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
RF_WORKER_TBL
|
| 3 |
START_DT |
Date(10) |
DATE |
Start date field to store start date value.
|
| 4 |
END_DT |
Date(10) |
DATE |
This field stores the end date values.
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
SO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Order ID
|
| 7 |
SO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Stores the Service Order line number.
|
| 8 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project ID
|
| 9 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
|
| 10 |
TASK_TYPE |
Character(18) |
VARCHAR2(18) NOT NULL |
Copied from Resouce Management (8.1). Added new label id for "Task Type"
|
| 11 |
SUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Sunday
Y/N Table Edit
Default Value: INSTALLATION.SUN
|
| 12 |
MON |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Monday
Y/N Table Edit
Default Value: INSTALLATION.MON
|
| 13 |
TUES |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Tuesday.
Y/N Table Edit
Default Value: INSTALLATION.TUES
|
| 14 |
WED |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Wednesday.
Y/N Table Edit
Default Value: INSTALLATION.WED
|
| 15 |
THURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Thursday.
Y/N Table Edit
Default Value: INSTALLATION.THURS
|
| 16 |
FRI |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Friday.
Y/N Table Edit
Default Value: INSTALLATION.FRI
|
| 17 |
SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Saturday.
Y/N Table Edit
Default Value: INSTALLATION.SAT
|
| 18 |
OVERRIDE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Flag
Y/N Table Edit
Default Value: N
|
| 19 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
Default Value: 1
|
| 20 |
MERCHANTID |
Character(30) |
VARCHAR2(30) NOT NULL |
Merchant ID
|
| 21 |
TIME_START |
Time(15) |
TIMESTAMP NOT NULL |
Start Time
|
| 22 |
SCHEDULED_HRS |
Signed Number(6,2) |
DECIMAL(4,2) NOT NULL |
Came from Resource Management - scheduled hours on the worker's daily calendar.
|
| 23 |
EXT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
External Resource
Y/N Table Edit
Default Value: N
|
| 24 |
EXT_USERID |
Character(70) |
VARCHAR2(70) NOT NULL |
External User ID
|
| 25 |
EXT_RATE_OFFERED |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Rate Offered
|
| 26 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 27 |
ASSIGNED_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
This is a field to store assignment information.
|
| 28 |
RESERVED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserved Flag
Y/N Table Edit
Default Value: N
|
| 29 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|