Peoplesoft syncronization with RDBMS

Synchronicity must be maitained between Peoplesoft record Definitions and the underlying SQL Table on the RDBMS.

If we need to change the record, we need to check the synchronization also. Summary of synchronization details are below

Field Properties

Change Affects Table Synchronicity

Change Affects Indexes

Change updates online system only

Field Name

X

Delete or Add Field

X

Type

X

Length

X

Label

X

Format

X

Translate Values

X

Use Properties

Change Affects Table Synchronicity

Change Affects Indexes

Change updates online system only

Key

X

Alt Srch key

X

Key Direction

X

Dup Order Key

X

Search Key

X

List Box Item

X

From/Thru Search

X

Rec Field Label

X

Default Value

X

Default Page Control

X

Audits

X

Edit Properties

Change Affects Table Synchronicity

Change Affects Indexes

Change updates online system only

Req (if char or num)

X

Req (if not char or Num)

X

Edit Type(any)

X

Reasonable Date

X

People Code

Change Affects Table Synchronicity

Change Affects Indexes

Change updates online system only

X

Article Posted by - Ganesh A.M



 

0 comments: