GetSupplementalDatatoUpdApplMst

Get Supplemental Data to Update Applicant Master

Minor Business Rule

Object Name: N0800072

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

The purpose of this NER is to update the Applicant Master (F08401) from the Supplemental Data program (P00092). When a user adds, changes or
deletes a record (the Applicant Status and or Status Date) this NER will be run to update the Applicant Master (F08401). This only applies to Supplemental
Database Code of 'A' with a Data Type of 'A'.

SetUp Notes

Technical Specifications

Parameters

Data Item Data Structure Description I/ORequiredTableNotes
AN8                   MnAddressNumber          IY
SDB                   SzDatabaseCode                IY
TYTD                   SzDataType                        IY

Based on the Supplemental Data Address Book Number (SBN1) being passed into this NER, retrieve the Supplemental Data record with most current
Applicant Status Date (EFT). In order to accomplish this, a new index needs to be added to the Supplemental Data file F00092. This index will be ordered by
Address Book Number (SBN1), Database Code (SDB), Data Type (TYDT), and Effective Date (EFT) descending. The NER will do one I/O to retrieve the
Supplemental Data record (using the new index) with the most current Effective Date.

The NER will fetch the Applicant Master record based on the passed Supplemental Data Address Book Number (SBN1). It will determine if the most
current Supplemental Data records' Applicant Status (KY) is not equal to the Applicant Status (APS) in the Applicant Master. Based on this comparison not
being true, the Applicant Master record will be updated with the new Applicant Status.

// Initialize Variables //
mnAddressBookNumber = FI_Address_Book_Number
szSDsdb  = FI_Database_Code
szSDtydt = FI_Data_Type

szSDstatus  = ' '
szAPstatus  = ' '

// Supplemental Data Index = (SDN1, SDB, TYDT, EFT [descending]) //

Select F00092 using mnAddressBookNumber, szSDsdb, szSDtydt

FetchNext
       If I/O Status is = Success
            szSDstatus = Supplemental Data User Define Code (KY)

             / Update Applicant Master record with most current date related information //
               FetchSingle F08401 using MnAddressBookNumber
               szAPstatus = Applicant Master Applicant Status
               If I/O Status is = Success
                         If szSDstatus is not = szAPstatus
                         Update F08401 with  szSDstatus
                         End
               End
       End

Related Tables

Table Table Description
F00092Supplemental Data
F08401Applicant Master

Processing

The call to this NER will need to be done on the form level events Update Record to DB After, Add Record to DB After and Delete Record from DB After.

^

Data Structure

DN0800072 - Get Supplemental Data to Update Applicant Master

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	OPT	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
szSupplementalDatabaseCode	SDB	char	OPT	INPUT
A user defined code (00/SD) that sets up databases for groups of related supplemental data types. This code differentiates the supplemental data types for various systems. For example, the Employee (E) supplemental database contains data types that you use to track additional employee information, such as education and job skills.
szTypeofData	TYDT	char	OPT	INPUT
A code that you assign to supplemental data so that you can group data by categories. Valid values include: A Approval steps B Requisition requirements C Interview process N Requisition notes
szProgramId	PID	char	OPT	INPUT
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.
szUserId	USER	char	OPT	INPUT
The code that identifies a user profile.
jdDateUpdated	UPMJ	JDEDATE	OPT	INPUT
The date that specifies the last update to the file record.
szWorkStationId	JOBN	char	OPT	INPUT
The code that identifies the work station ID that executed a particular job.

Related Functions

None

Related Tables

None