| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
PROVIDER_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Default Value: NEXT
|
| 3 |
NAME1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Generic 50 character name field for storing names.
|
| 4 |
PROVGRP_TYPE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Code used to determine the type (internal, external, etc.) of provider group.
01=Internal
02=Partner/TPM
03=Both
Default Value: 01
|
| 5 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 6 |
RB_WF_GRP_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Group Worklist Nameg
Prompt Table:
RB_WF_WL_GRP
|
| 7 |
RC_MANAGER |
Character(15) |
VARCHAR2(15) NOT NULL |
Call Center Manager. Used in call center business unit setup.
Prompt Table:
RC_MGR_NAME_VW
|
| 8 |
USE_MEMBER |
Character(1) |
VARCHAR2(1) NOT NULL |
Provider group flag indicating that all members of the provider group should also receive notifications.
Y/N Table Edit
Default Value: N
|
| 9 |
COMPANYID |
Character(15) |
VARCHAR2(15) NOT NULL |
Company ID
Prompt Table:
RF_COMP_SRCH_VW
|
| 10 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email address to store the address of email.
|
| 11 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table:
PSTIMEZONE
|
| 12 |
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
|
| 13 |
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
|
| 14 |
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
|
| 15 |
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
|
| 16 |
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
|
| 17 |
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
|
| 18 |
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
|
| 19 |
HOLIDAY_SCHEDULE |
Character(6) |
VARCHAR2(6) NOT NULL |
This is the holiday schedule field.
Prompt Table:
HOLIDAY_TBL
|
| 20 |
COMMENTS_2000 |
Long Character(32700) |
CLOB |
Comment Text
|
| 21 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table:
CURRENCY_CD_TBL
|
| 22 |
PREF_WF_ROUTE_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred workflow notification method. E.g., Email, Worklist, or Both.
B=Both
E=Email
W=Worklist
|
| 23 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 24 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 25 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 26 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 27 |
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.
|
| 28 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|