| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TASK_TYPE |
Character(18) |
VARCHAR2(18) NOT NULL |
Copied from Resouce Management (8.1). Added new label id for "Task Type"
|
| 2 |
ACTIVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active
N=Inactive
Y=Active
Y/N Table Edit
Default Value: Y
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
APPLICATION_USAGE |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Usage. Holds the info about the application.
ALL=All Applications
CHMG=Change Management
EVNT=Marketing Events
FLDS=Field Service
HIED=Higher Education
HLPD=HelpDesk
HRHD=HR Helpdesk
LEAD=Lead
OPPY=Opportunity
PIM=Personal Information Mgmt
RSP=Strategic Planning
SALS=Sales
SUPP=Support
Default Value: ALL
|
| 5 |
COMPLETION_RULE |
Character(4) |
VARCHAR2(4) NOT NULL |
Holds Rule to To Complete a Task.
ALL=All Assignees Accept Task
ONE=One Assignee Accepts Task
|
| 6 |
SHOW_IN_LIST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Task should be shown in Task List. Used by Task Management.
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 7 |
RB_PENCIL_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Pencil In indicator for Task Calendar. Used in Task Type definition.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 8 |
RB_RECORD_ATTEND |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Attendance indicator for Task calendar.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 9 |
SHOW_IN_CAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Task should be shown in Calendar. Used by Task Management.
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 10 |
INCL_AVL_HOUR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to indicate if the duration of the task should be included in available work hours.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 11 |
RS_RESOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
On the Task Type component for the calendar tasks, this determines if the user is allowed to add or delete this type of task from their own calendar.
|
| 12 |
START_DT_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Start date is Visible. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 13 |
START_DT_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Start date is required. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 14 |
START_TM_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Start Time is required. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 15 |
START_TM_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Start Time is visible. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 16 |
END_DT_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if End Date needs to be visible.
Y/N Table Edit
Default Value: N
|
| 17 |
END_DT_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if End Date Required.
Y/N Table Edit
Default Value: N
|
| 18 |
END_TM_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate End time is required. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 19 |
END_TM_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the end time is visible. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 20 |
LOCATION_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Location is visible. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 21 |
LOCATION_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Location is required. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 22 |
INV_TYPE_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invitation type visible flag.
Y/N Table Edit
Default Value: N
|
| 23 |
REMIND_ME_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Remind me flag. Used by Task Management.
Y/N Table Edit
Default Value: N
|
| 24 |
ASSGN_GRID_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Type Assigne To Grid visibility flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 25 |
CNTCT_GRID_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task Type Contact Grid Title visibility flag
Y/N Table Edit
Default Value: N
|
| 26 |
PROVGRP_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if a provider group can be assigned to a task.
Y/N Table Edit
Default Value: N
|
| 27 |
MESSAGE_NBR01 |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 2322
Prompt Table:
RB_TSK_MSGCATVW
|
| 28 |
MESSAGE_NBR02 |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 2321
Prompt Table:
RB_TSK_MSGCATVW
|
| 29 |
MESSAGE_NBR03 |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 2399
Prompt Table:
RB_TSK_MSGCATVW
|
| 30 |
SHOW_REPEAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Repeating Options for Task Type in Task Management
Y/N Table Edit
Default Value: N
|
| 31 |
IMAGE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of images used in Personalizations explanations.
Prompt Table:
RB_DIST_CONT_VW
|
| 32 |
PIM_OUTLOOK_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Outlook Integration mapping. Used by Task Management for PIM
A=Appointment
C=Meeting
E=All Day Event
T=Task
Default Value: T
|
| 33 |
PIM_NOTES_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lotus Notes Integration mapping. Used by Task Management for PIM
A=Appointment
E=All Day Event
M=Meeting
N=Anniversary
R=Reminder
T=To Do
Default Value: T
|
| 34 |
TXN_LINK_VIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the Start date is Visible. Used by Task Management.
Y/N Table Edit
Default Value: Y
|
| 35 |
RC_MAINT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
|
| 36 |
SYSD_APPLICATION01 |
Character(1) |
VARCHAR2(1) NOT NULL |
PS CRM Core
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 37 |
SYSD_APPLICATION02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Services
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 38 |
SYSD_APPLICATION03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Telecommunications
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 39 |
SYSD_APPLICATION04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Government
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 40 |
SYSD_APPLICATION05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Energy
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 41 |
SYSD_APPLICATION06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 42 |
SYSD_APPLICATION07 |
Character(1) |
VARCHAR2(1) NOT NULL |
High Technology
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 43 |
SYSD_APPLICATION08 |
Character(1) |
VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 44 |
SYSD_APPLICATION09 |
Character(1) |
VARCHAR2(1) NOT NULL |
System Data Field for Application 9. Application 9 is used for Wealth Management.
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 45 |
SYSD_APPLICATION10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in Application 10
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 46 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 47 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 48 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 49 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 50 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 51 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 52 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|