DetermineRecordStatusCode

Determine Record Status Code

Minor Business Rule

Object Name: N0500005

Parent DLL: CFND

Location: Client/Server

Language: NER

Functional Description
The purpose of this Named ER is to determine what the record status code is based on several possibilities.

Setup Notes

Technical Specifications

Parameters

Data Item         Data Structure Description       I/ORequiredTableNotes
AN8        Address Number               I
USR         Payroll Lockout Code I
GICU         GL Batch Number                I
ICC           Interim Check CodeI
PDBA               DBA Code             I
PID          Program ID             I
PHRW          Hours Worked                I
RCOW**Record Status Code            OOutput of this NER
                                (Timecard Inidicator)
CKCN           Check Control Number ICKCN from FI value, NOT F06116
EV01                     Locked Flag                 OWorkfield to determine if Locked label should
                                                                 display in header of form..
EV01       Error Flag                   O
EV01       ProcessingOptionLockoutIInput from application processing option
USR           F07300 User            IUSR retrieved from F07300 used in determining
                                                                    Record Status Code
EV01        Called From Interims FlagIFlag to determine if time entry is called from the Interims process.

** Set up DD item for this'85e.g. RCOW (#PR on AS/400)

Related Tables

Table Table Description
F069096Payroll Constant
F06116Employee Transactions Detail

Processing

1.Check record for special status using the following guidelines. Each subsequent check should override the previous. Use the specified code to
display in the status code workfield on the grid. Where noted, the record should also be locked from changes.

Simple Lockout-------"L" Lockout code (USR) is not equal to blank. The record is still available for change. The 'lockout' logic to be added in
B73.3 will check for changes to records with status 'L'.

Protected Lockout---"A"Lockout code (USR) is not equal to blank and a Payroll process is active for this timecard's version ID (see section
'Check Payroll Version Status'). The record should be locked from all changes.

Posted Record---------"P"GL Batch Number (GICU) is not equal to blank. The record should be locked from all changes.

Interim Record--------"I" Interim Check Code (ICC) is equal to 'Y' (record was originally created within the Interim check process)  and CKCN
(parameter list) is zeros.  The record should be locked from all changes.  (If the Time Entry session IS called from Interims, CKCN in the parm list will
not be zeros.  Do not display the status code and do allow changes to the record.)

Checks Record--------"C"Check process is active or has been run for this version (see section 'Check Payroll Version Status').  The record
should be locked from all changes.

Final Update Active-"F"Final Update is active for this version (see section 'Check Payroll Version Status').  The record should be locked from
all changes.

Human Resources ---"H" - Must validate PDBA code first, set this code if data item SACC from F069116 is not equal to blank.  The record
should be locked from changes.

Reversing Entry from Auto Timecard Generator ----"R"  Program ID (PID) is equal to P061501 and Hours Worked (PHRW) is less than zero.  The
record should be locked from changes.

Record status code will be displayed as an output only field with each grid record.

All functionality will be available with the B73.3 release.

If GICU != 0
RSC = 'P'
Lockedflag ='1'

ElseIf ICC != blank

RSC = 'I'
Lockedflag ='1'

Elseif (ProcessingOption ='1') & (USR != F07300usr)

RSC ='L'
Elseif USR != blank
RSC = 'L'
Lockedflag ='1'
End
If ErrorFlag = '2' & USR != blank
RSC = 'A'
Lockedflag ='1'
Elseif ErrorFlag = '3' & USR != blank
RSC ='C'
Lockedflag ='1'
End

If USR != blank and payroll process **Not B73.2
RSC = 'A'
End

If PID = 'P061501' and PHRW <0
RSC = 'R'
End

Open/Fetch Single F069116 using PDBA
Return SACC
If SACC != blank
RSC = 'H'
End

Data Structure

DN050005 - Determine Record Status Code

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	NONE	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnGeneralLedgerBatch	GICU	MATH_NUMERIC	NONE	NONE
The batch number which has been assigned to the group of Journal Entries generated in the Payroll System. This number ties the entries together all of the way through Final Update and into the General Ledger Post program.
cInterimCheckCode	ICC	char	NONE	NONE
For OneWorld: A code that indicates one of the following conditions: Blank The payment was processed in a regular payroll cycle. I The payment was processed as an interim. Interim payments can include replacements for both regular voided payments and manually voided payments. X The payment is an original payment that has been voided. For World: An internal code that indicates one of the following conditions: o The time and pay record is for an interim payment. o The record in the Payment table (F07350) is an interim payment. o An employee has an interim payment in the Payment table for the current pay period. Valid codes are: X The payment has been voided. V The payment is a void of a previously-entered payment. I The payment was processed as an interim check. Blank The payment was processed in a regular payroll cycle.
szProgramId	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
mnHoursWork	PHRW	MATH_NUMERIC	NONE	NONE
The number of hours associated with each transaction.
cLockedFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnPayDeductBenAccType_2	PDBA	MATH_NUMERIC	NONE	NONE
A code that defines the type of pay, deduction, benefit, or accrual. Pay types are numbered from 1 to 999. Deductions and benefits are numbered from 1000 to 9999.
cPayrollTimecardIndicator	RCOW	char	NONE	NONE
A code that indicates the status of a timecard related to other payroll functions. Valid values are: A A step of the payroll cycle is active. This timecard is protected. C Checks have been printed for this payroll. This timecard is protected unless checks are reset. F The final update for payroll is active. The timecard is protected. I This timecard belongs to an interim check. This timecard is protected. You can only change this timecard using the Interims Workbench. L This timecard is locked because Pre-Payroll has been run. You can change locked out information if you are authorized to do so, but you must run a Changes Only payroll when you do. M This timecard was created using the Time Entry Interim Generator. If you change this timecard, you must process the Interim ID associated with this timecard from the Interim Payment Workbench in order to update the interim payment. P Journal Entries have already been created (posted). This timecard is protected. ! You have attempted to enter a timecard into an active payroll. An entry is not allowed. R Reversing timecard created by the Automatic Timecard Generator for a timecard posted by Special Timecard Post.
cErrorFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cProcessingOptionLockout	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cCalledFromInterimsFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szTimecardIdentification	USER	char	OPT	NONE
The code that identifies a user profile.
szCurrentUser	USER	char	OPT	NONE
The code that identifies a user profile.
szPayrollLockoutIdentifi	USR	char	OPT	NONE
This code is a combination of the IBM user ID and the batch number assigned to a prepayroll selection. It is used to prohibit one employee from being processed in more than one concurrent payroll cycle. It also locks out everyone but the user who is running the payroll (or prepayroll) from updating the employee's master file or time records until either the the cycle is complete or a reset of the payroll lockout is executed.
cDefaultInterimID	DEFINT	char	OPT	NONE
An option that identifies an Interim ID as the default. You can set up one default interim ID for each Pay Cycle and Country Code combination that your organization uses. You must set up at least one default Interim ID if you generate interim payments using the Time Entry Interim Generator. Note: In order for the Time Entry Interim Generator to function properly, you must set up a default interim ID and you must complete the processing options for the Time Entry Master Business Function (P050002A). If the default interim ID and the Master Business Function processing options are set up correctly, the default interim ID is displayed on the time entry form that you use to generate interim payments using the Time Entry Interim Generator.
mnCheckControlNumber	CKCN	MATH_NUMERIC	OPT	NONE
A number used to group all payroll transactions for each payment or individual interim payment. This number is carried into the accounting journal entries and facilitates the update of the actual check number after payment printing is complete. This number is also used for automatically voiding payments. The payment work table contains both the actual check number and the check control number. All associated payment transactions are automatically reversed using the check control number. This is not the actual check number.

Related Functions

None

Related Tables

None