| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 APPLICATION_OWNER |
Character(4) |
VARCHAR2(4) NOT NULL |
Describes the Card or Chart Owner (i.e. RC, RO etc.)
This field was originally designed to be used for Electronic Cards, but has been expanded to include other applications, such as Charts.
RC=Call Center
RF=FieldService
RO=Order Capture
RY=Online Marketing
|
| 2 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 3 |
CHART_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
This field is used to define the chart that is used in the Manager's Desktop Portal.
|
| 4 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 5 |
X_AXIS_MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
This Message number is used to determine the X-Axis Label for Portal Charting.
|
| 6 |
Y_AXIS_MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
This Message number is used to determine the X-Axis Label for Portal Charting.
|
| 7 |
CHART_SQL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
This field defines the Chart SQL to use when the user has selected a Chart (CHART_NAME) to display.
|
| 8 |
CHART_SQLEXEC_ID |
Number(3,0) |
SMALLINT NOT NULL |
This field will allow the developer to use different SQLExec's in the WEBLIB_RC.RC_CHARTS FieldFormula PeopleCode and alter program logic flow (if so desired).
Allowing this versatility, the develper can add more complex SQLExec statements to produce a wide array of Charts.
Default Value: 1
|
| 9 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 10 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 11 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 12 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 13 |
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.
|
| 14 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|
| 15 |
RC_MAINT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Call center Maintenance Owner
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
|
| 16 |
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
|
| 17 |
SYSD_APPLICATION02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Services
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 18 |
SYSD_APPLICATION03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Telecommunications
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 19 |
SYSD_APPLICATION04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Government
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 20 |
SYSD_APPLICATION05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Energy
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 21 |
SYSD_APPLICATION06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 22 |
SYSD_APPLICATION07 |
Character(1) |
VARCHAR2(1) NOT NULL |
High Technology
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 23 |
SYSD_APPLICATION08 |
Character(1) |
VARCHAR2(1) NOT NULL |
HR HelpDesk
N=No
S=Sample Data
Y=Yes
Y/N Table Edit
Default Value: N
|
| 24 |
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
|
| 25 |
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
|