SHARE:  

Table Changes Internal Integrations Testing

Monday, Nov. 11– Wednesday, Nov. 20, 2024

TO: GeorgiaFIRST Peoplesoft Financials Users



The GeorgiaFIRST Financials Release 6.00 scheduled for Friday, December 13, 2024, includes table changes that may affect third party integrations. ITS recommends that all institutions using institution specific integrations such as SAS, Business Objects, or other reporting software test these integrations prior to the release. Institution resources responsible for local integrations and reporting may notice the new fields (table columns) in the database. ITS is not changing any business process or PeopleSoft Financials functionality as a result of these table changes.

 

Institutions will use the FTEST2 environment for this testing. To gain access, users will need to contact the ITS Helpdesk here for password information. 

 

Table Name

Type of Change

PSOPRDEFN

New column: PTACCTNEVERLOCK

PS_PERSONAL_DATA

PS_PERS_DATA_EFFDT

New columns:

NAME_DISPLAY

NAME_FORMAL

PREF_MIDDLE_NAME

PREF_LAST_NAME

KNOWN_FIRST_NAME

KNOWN_MIDDLE_NAME

KNOWN_LAST_NAME

KNOWN_NAME

NAME_DISPLAY_SRCH

NAME_FORMAL_SRCH

MIDDLE_NAME_SRCH

PREF_FIRST_NM_SRCH

PREF_MIDL_NM_SRCH

PREF_LAST_NM_SRCH

PREF_NAME_PREFIX

PREF_NAME_SUFFIX

PREF_NAME_TITLE

PREF_SEC_LAST_NAME

PREF_LAST_SEC_SRCH

PARTNER_LAST_NAME

PARTN_LAST_NM_SRCH

PARTNER_ROY_PREFIX

RES_SYSTEM_SOURCE

PS_EX_SHEET_LINE

New columns:

LATITUDE1

LONGITUDE1

START_POINT_SELECT

LATITUDE2

LONGITUDE2

END_POINT_SELECT

DISTANCE_SELECT

MORE INFORMATION AND SUPPORT: For business impact issues, contact OneUSG Connect Support at oneusgsupport@usg.edu.. 


View this email in your browser