Details
Dates
Wed 12/1/21
-
Tue 3/8/22
Acct/Dept
Payroll Services
Service
OIT Project Requests / Information Technology Project Requests
Type
Information Technology / Application Development
Health
None - No health has been set
Portfolio(s)
-
IT Project Requests - Administrative Services
(Jason Dudley)
Classification
Administrative Services
Requirements
Programming update to PZREPAR
Created
Fri 8/27/21 8:08 AM
Modified
Tue 3/8/22 2:51 PM
Closed
Tue 3/8/22 2:51 PM
IT Project Custom Attributes
DivisionAdministrative Services
IT Project TypeProgramming Request
Number of Users ImpactedPlease indicate the number of users impacted by this project.
all FRS employees
Description
SELECT a1.spraddr_street_line1, a1.spraddr_street_line2,
a1.spraddr_city, a1.spraddr_stat_code,
substr(a1.spraddr_zip,1,5) || substr(a1.spraddr_zip,7,4)
FROM spraddr a1
WHERE a1.spraddr_atyp_code = 'MA' AND
a1.spraddr_seqno =
(SELECT MAX(a2.spraddr_seqno)
FROM spraddr a2
WHERE a2.spraddr_pidm = a1.spraddr_pidm
AND a2.spraddr_atyp_code = a1.spraddr_atyp_code ---To fix issue of not returning address. JR 2/8/17
) AND
a1.spraddr_pidm = demo_pidm;
address code is not looking at address status. When employee addresses are updated the sequence numbers do not always default as the max or highest sequence as the code is requesting, resulting in old non active addresses to be pulled.
Request to have the extract to pull Active MA addresses.