| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID
Prompt Table:
OPRID_VW2
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
RS_CREATE_APPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate that the tasks in the schedule will create the appointment entries.
Y/N Table Edit
Default Value: N
|
| 5 |
RS_CREATE_ASGN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Assignment
Y/N Table Edit
Default Value: N
|
| 6 |
DELETE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Loaded Items
Default Value: N
|
| 7 |
RS_UPGRADE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process as an upgrade
Y/N Table Edit
Default Value: N
|
| 8 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
RS_WRKR_SRCH
|
| 9 |
DATE_UNDER_RPT |
Date(10) |
DATE |
Date Under Report
Default Value: %Date
|
| 10 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 0
|
| 11 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 12 |
ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
Prompt Table:
RS_ASSIGNMENT
|
| 13 |
RS_APPT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Appointment Id
Prompt Table:
RS_APPOINTMENT
|
| 14 |
TASK_TYPE |
Character(18) |
VARCHAR2(18) NOT NULL |
Task Category
|
| 15 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 16 |
TIME_START |
Time(15) |
TIMESTAMP |
Start Time
Default Value: %Time
|
| 17 |
SCHEDULED_HRS |
Signed Number(10,4) |
DECIMAL(8,4) NOT NULL |
Scheduled Hours
|
| 18 |
SCHEDULE_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source of the scheduled event
O=Other
R=Batch-Generated Read Only
S=System-Generated
|
| 19 |
MAPI_ENTRY_ID |
Character(254) |
VARCHAR2(254) NOT NULL |
Entry Id ( MAPI)
Default Value: 1
|
| 20 |
RS_APPT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Appointment Type
ACT=Activity
ASN=Assignment
DAY=All Day Event
MTG=Meeting
|
| 21 |
RS_REPEAT_MONTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Repeat for Month
F=from first
L=from last
|
| 22 |
SYNCH_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronization Flag used to indicate the level of synchronization during a physical inventory snapshot.
0=No Synchronization Required
1=Synchronize a Business Unit
2=Synchronize an Item
3=Synchronize a Storage Location
4=Synchronize a Lot ID
5=Synchronize Item at a Stor Loc
|
| 23 |
RS_CALSYNC_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sync All Calendars
Y/N Table Edit
|