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 |
Posts
