RB_TSK

(SQL Table)
 Index Back

Task Detail Table

Holds all the Task Detail Information. Used by Task Management.

  • Related Language Record: RB_TSK_LANG

  • Parent Record Of RB_TSK_ASN_O_VW RB_TSK_CNTCT RB_TSK_CNTCT_VW RB_TSK_NOTE RB_TSK_NOTE_WS RB_TSK_NOT_LANG RB_TSK_RPT_CUST RB_TSK_TXN RB_TSK_TXN_WRK RB_TSK_TXN_WS RD_CR_NOTE_WS RD_CR_TXN_WRK RD_CR_TXN_WS RIM_TSKASGN_PER RIM_TSKASN_O_VW RIM_TSKCNT_ASGN RIM_TSK_CNTCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASK_ID Number(15,0) DECIMAL(15) NOT NULL TaskIID field. Key for RB_TSK record. Used by Task Management.

    Default Value: 999999999999

    2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Task Subject
    3 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

    Prompt Table: RB_TSK_TYPE

    4 TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Task Status
    CMPL=Completed
    CNCL=Canceled
    INPR=In Progress
    OPEN=Open

    Default Value: OPEN

    5 TASK_PRIORITY Character(4) VARCHAR2(4) NOT NULL Task Priority indicator for Task. Used in Task Management.

    Prompt Table: RB_TSK_PRTY_VW

    6 START_DATE Date(10) DATE Start Date
    7 START_TIME Time(15) TIMESTAMP Start Time
    8 END_DATE Date(10) DATE End date field to store an end date.
    9 END_TIME Time(15) TIMESTAMP End Time
    10 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

    Prompt Table: PSTIMEZONE

    11 TASK_LOCATION Character(30) VARCHAR2(30) NOT NULL Task Location. Used by Task Management.
    12 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: %EDITTABLE

    13 PRIVATE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate the Task is Private. Used by Task Management.

    Y/N Table Edit

    Default Value: N

    14 PARENT_TASK_ID Number(15,0) DECIMAL(15) NOT NULL Parent Task of an existing Task. Used by Mobile Task Management.

    Prompt Table: RB_TSK

    15 REMINDER_DURATION Number(6,0) INTEGER NOT NULL Reminder Duration. Used by Task Management.
    16 REMINDER_UNITS Character(4) VARCHAR2(4) NOT NULL Reminder Units. Used by Task Management.
    DAYS=Days
    HOUR=Hours
    MINS=Minutes
    17 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

    18 REPEAT_TYPE Character(4) VARCHAR2(4) NOT NULL Repeat Type. Used by Task Management.
    CUST=Custom
    DAIL=Daily
    MNTH=Monthly
    NONE=Does Not Repeat
    WEEK=Weekly
    YEAR=Yearly

    Default Value: NONE

    19 REPEAT_DAY_FREQ Character(4) VARCHAR2(4) NOT NULL Frequency - Daily. Used by Task Management.

    Default Value: 1

    20 REPEAT_WEEK_FREQ Character(4) VARCHAR2(4) NOT NULL Frequency repeat weekly. Used by Task Management.
    1=Every 01 Week
    10=Every 10 Weeks
    11=Every 11 Weeks
    12=Every 12 Weeks
    2=Every 02 Weeks
    3=Every 03 Weeks
    4=Every 04 Weeks
    5=Every 05 Weeks
    6=Every 06 Weeks
    7=Every 07 Weeks
    8=Every 08 Weeks
    9=Every 09 Weeks

    Default Value: 1

    21 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: N

    22 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: N

    23 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: N

    24 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: N

    25 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: N

    26 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: N

    27 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: N

    28 REPEAT_MNTH_FREQ Character(4) VARCHAR2(4) NOT NULL Frequency, repeat monthly. Used by Task Management.
    1=Every 01 Month
    10=Every 10 Months
    11=Every 11 Months
    12=Every 12 Months
    13=Every 13 Months
    14=Every 14 Months
    15=Every 15 Months
    16=Every 16 Months
    17=Every 17 Months
    18=Every 18 Months
    2=Every 02 Months
    3=Every 03 Months
    4=Every 04 Months
    5=Every 05 Months
    6=Every 06 Months
    7=Every 07 Months
    8=Every 08 Months
    9=Every 09 Months

    Default Value: 1

    29 REPEAT_BY_DATE Character(4) VARCHAR2(4) NOT NULL Repeat by Date. Used by Task Management.
    30 REPEAT_BY_DAY Character(4) VARCHAR2(4) NOT NULL Repeat by day. Used by Task Management.
    31 START_FROM_END_FLG Character(1) VARCHAR2(1) NOT NULL Count fro end of month. Used by Task Management.

    Y/N Table Edit

    Default Value: N

    32 REPEAT_YEAR_FREQ Character(4) VARCHAR2(4) NOT NULL Repeat Yearly frequency. Used by Task Management.
    1=Every 01 Year
    10=Every 10 Years
    2=Every 02 Years
    3=Every 03 Years
    4=Every 04 Years
    5=Every 05 Years
    6=Every 06 Years
    7=Every 07 Years
    8=Every 08 Years
    9=Every 09 Years

    Default Value: 1

    33 REPEAT_YEAR_MNTH Character(4) VARCHAR2(4) NOT NULL Repeat Year - Month. Used by Task Management.
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    34 REPEAT_MOVE_OPTION Character(4) VARCHAR2(4) NOT NULL Move option if the repeat task occures on weekend. Used by Task Management.
    DELE=Don't Create Task
    DONT=Don't Move
    NEXT=Move to Next Work Day
    PREV=Move to Previous Work Day

    Default Value: DONT

    35 REPEAT_MAX_OCCUR Number(4,0) SMALLINT NOT NULL Maximum repeat occurances. Used by Task Management.
    36 REPEAT_END_DATE Date(10) DATE Repeat end date. Used by Task Management.
    37 SETID_PROV_GRP Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    38 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
    39 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    40 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    41 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    42 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    43 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.
    44 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    45 DESCRLONG Long Character CLOB Long Description
    46 PIM_MEETING_GUID Character(254) VARCHAR2(254) NOT NULL This field stores the MeetingLinkingGUID from Intellisync EA software
    47 RBP_ORIG_MTG_DTTM DateTime(26) TIMESTAMP Original meeting start datetime. Use this to concatenate the Original Start Date and Original Start Time of CRM calendar entry.
    48 EXTERNAL_FLG Character(1) VARCHAR2(1) NOT NULL business projects external source indicator

    Y/N Table Edit

    Default Value: N