need assistance in writing a python$3.$x and require explicit details : Command Run

Python command should be something like the following, where translation.py is the name of the python script file.

python translation.py DP$611.$SDF $2024-05-25-2024-06-01($yyyy$-$m$-$d$)$

SDF Translation

First column:

Ignore $!$ lines

$$X$$ lines are Per Performance Employees

$$W$$ lines are regular employees

First zero $0$ after $$W$,$ or $$X$$ is ignored

Ensure only converting $611$EMS$$ rows

Translation

Translate SSN to EID using the last$-4$ digits of the SSN

NOTE: Luke M$.$ will providing a EMS CSV of SSN$/$EID mapping that will have either the last $4$ or last $5$ of the SSN

Per$-$performance Output

Should output to single CSV file called $611-$EMS$-$PP$-\{$PPdatehere$\}.$csv$.$

$\{$employee id$\},\{$end date of time period$\},$Performances,$\{$number of hours$\}$

e$.$g$.6564,2024-06-01,$Performances,$36\mathrm{.}00$

The two possible dates are teh Week $1$ and Week $2$ Ending Saturday dates.

For the pay period ending $2024-05-15$ the two dates would be either $2024-06-08$ or $2024-06-15.$

Regular Employees Output

Should output to single CSV file called $611-$EMS$-$BW$-\{$PPdatehere$\}.$csv$.$

Example

W$0$XXXXXXXXX$611$EMS $24001200540012008400000001203303000$K$5716$S$15$G$4$

Columns:

Interpret as noted above

$[$Week$1$Shifts$]$

$[$Week$1$StraightOvertime$]$

$[$Week$1$FLSAOvertime$]$

$[$Week$2$Shifts$]$

$[$Week$2$StraightOvertime

$[$Week$2$FLSAOvertime$]$

$[$Docked$]$

$[$Vacation$]$

$[$SickLeave$]$

$[$CompTimeEarned$]$

$[$CompTimeTaken$]$

$[$Week$1$FireShift$]$

$[$Week$2$FireShift$]$

$[$MedicalLeave$]$

Output by row:

Vacation Used Info from Col $9($always use end date of PP$)$

$2384,2024-06-01,$Vacation Used Info,$24\mathrm{.}00$

Shift Pay City $($Week $1)$ from Col $2$

$2280,2024-05-25,$Shift Pay City,$4\mathrm{.}00$

Shift Pay City $($Week $1)$ from Col $5$

$2280,2024-06-01,$Shift Pay City,$5\mathrm{.}00$

ST Overtime $($Week $1)$ from Col $3$ & $4($summed$)$

$2384,2024-05-25,$ST Overtime,$4\mathrm{.}00$

ST Overtime $($Week $2)$ from Col $6$ & $7($summed$)$

$2384,2024-06-01,$ST Overtime,$4\mathrm{.}00$

Docked Pay from Col $8($always use end date of PP$)$

$4352,2024-06-01,$Docked Pay,$84\mathrm{.}00$

Medical Used Info from Col $15($always use end date of PP$)$

$182,2024-06-01,$Medical Used Info,$12\mathrm{.}00$

Note that number on SDF has $1$ decimal place, but gets translated to $2$ here.

Sick Used Info from Col $10$

$2384,2024-06-01,$Sick Used Info,$2\mathrm{.}00$