RetrieveFromEmpContactWorkTable

Various I/O for F054111W

Minor Business Rule

Object Name: N0800391

Parent DLL: CHRM

Location: Client/Server

Language: NER

Data Structure

D0800391 - Retrieve from Employee Emergency Contact Work Table

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnMode	MATH01	MATH_NUMERIC	REQ	INPUT
- - - Good Performance Low Value.
szError	DTAI	char	OPT	OUTPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
mnAddressNumber	AN8	MATH_NUMERIC	OPT	BOTH
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnLineNumberID	IDLN	MATH_NUMERIC	OPT	BOTH
This field is used to identify the line ID number for a Who's Who record.
szSalutationName	SLNM	char	OPT	BOTH
The name that you would use to address an individual in written correspondence. Examples include Ms. Green, Dr. Strasheim, Herr Obermeyer, Mr. Pitt. The software does not use the value in this field in any reports. It is informational only.
szNameMailing	MLNM	char	OPT	BOTH
The company or person to whom billing or correspondence is addressed.
szNameGiven	GNNM	char	OPT	BOTH
The first name of an individual. This field is informational only.
cMiddleInitial	IMN	char	OPT	BOTH
The first letter of the individual's middle name. This is primarily used to facilitate certain statutory reporting requirements.
szNameSurname	SRNM	char	OPT	BOTH
The last name of an individual. This field is informational only.
szAddressLine1	ADD1	char	OPT	BOTH
The first line of a mailing address for an employee, customer, or supplier in the Address Book system. The U.S. Internal Revenue Service (IRS) restricts the size of the address that prints on an employee's year-end tax return. To comply with IRS regulations, the system has the following restrictions: o On W-2 returns, the system prints only the last three nonblank address lines plus the city, state, and postal code. o On 1099 returns, the system prints only the last nonblank address line plus the city, state, and postal code. o On other U.S. federal magnetic media, the system prints only the last nonblank address line plus the city, state, and postal code.
szUpdatedBy	UPID	char	OPT	BOTH
This field is updated with the name of the person who last updated the tag.
mnMUUpdateTime	MUMT	MATH_NUMERIC	OPT	BOTH
Time that object was updated.
jdMUUpdateDate	MUMJ	JDEDATE	OPT	BOTH
Date that the object was updated.
szESignature	ESIGN	char	OPT	BOTH
A code that identifies an electronic signature that the system assigns when an employee approves of an action in a self-service process.
mnTimeLastUpdated	UPMT	MATH_NUMERIC	OPT	BOTH
The time that specifies when the program executed the last update to this record.
jdDateUpdated	UPMJ	JDEDATE	OPT	BOTH
The date that specifies the last update to the file record.
szWorkStationId	JOBN	char	OPT	BOTH
The code that identifies the work station ID that executed a particular job.
szProgramId	PID	char	OPT	BOTH
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	BOTH
The code that identifies a user profile.
cActionFlag	ACFL	char	OPT	BOTH
A field that defines the type of change that will be made to a record. This flag is used by the system in subsequent record processing.
szRemark1	REM1	char	OPT	BOTH
A 40-character field that you can use to enter text.
mnSequenceNumber52Display	DSS5	MATH_NUMERIC	OPT	BOTH
A number that specifies the order of a group of records on the form.
szContactTitle	ATTL	char	OPT	BOTH
The professional title of a Who's Who person.
cTypeCode	TYC	char	OPT	BOTH
A user defined code (01/W0) that identifies the Who's Who entry. Examples include: A Attention name B Billing C Contact name E Emergency Contact O Other T 1099 legal name
szCountry	CTR	char	OPT	BOTH
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion. The Address Book system uses the country code for data selection and address formatting.
szZipCodePostal	ADDZ	char	OPT	BOTH
The United States ZIP code or the postal code that specifies where a letter is to be routed. Attach this code to the address for delivery in other countries. This code is used as the low end value when doing Postal Code Transaction range processing.
szState	ADDS	char	OPT	BOTH
A user defined code (00/S) that specifies the state or province. This code is usually a postal service abbreviation.
szCity	CTY1	char	OPT	BOTH
A name that indicates the city associated with the address.

Related Functions

None

Related Tables

None