F0005ExporttoFlatFile

F0005 - Export to Flat File

Minor Business Rule

Object Name: N0500044

Parent DLL: CFND

Location: Client/Server

Language: NER

1.Functional Description

1.1Purpose
The purpose of this function is to create one text string that contains the narrative text from the HR World file F08093. This file may have multiple records
that make up a single narrative. In One World, the narrative is stored in a BLOB on a single record.

1.2Setup Notes and Prerequisites
This function is intended to be called from the ER in the Supplemental Data Conversion UBE R96SDB731.  After the formatted string is received from this
function, a Media Object system function will be called that will write the narrative text to the One World Generic Text file F00165.

1.3Special Logic

2.Technical Specifications

2.1Parameters:
Data Item Data Structure Description I/ORequiredNotes
RCOD     World Supplemental            IY
Database Code
TYRC      Type Data                              IY
AN8        Address Number                                IY
JBCD      Job Type                                     I Y
JBST       Job StepI                               Y
KY           User Defined Code                IY
EFT         Effective Date                               IY
TXVC     Text String BLOBO               Y

2.2Related Tables
Table Table Description
F08093World Supplemental Data Narrative Text File

2.3Related Business Functions - Review and Copy Code
Source NameFunction Name

Processing

/* Initialize the work variable */
TextString = ' ';

/* Fetch record from World HR Narrative Text File F08093 */
Fetch_F08093( RCOD, TYRC, AN8, JBCD, JBST, KY, EFT);

While Not EOF(F08093)

/* Concatinate the text for this record to the work variable 'TextString' */
TextString = concat( TextString, F08093.Text );

/* Fetch Next Record */

Fetch_F08093( RCOD, TYRC, AN8, JBCD, JBST, KY, EFT);

EndWhile

Return(TextString);

^

Data Structure

D0500044 - F0005 - Export to Flat File

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSystemCode	SY	char	REQ	INPUT
A user defined code (98/SY) that identifies a system. Valid values include: 01 Address Book 03B Accounts Receivable 04 Accounts Payable 09 General Accounting 11 Multicurrency
szUserDefinedCodes	RT	char	REQ	INPUT
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.
cStatus	STA	char	OPT	OUTPUT
A user defined code (05/CR) that indicates the progress that the employee has made toward a level of proficiency in a particular competency. For example, for certification competencies, you might define a status, Pending, to indicate that the employee has completed a certification test but has not yet received his or her test scores.
cDelimitor	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
cCodeLength	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szUserDefinedCode	KY	char	REQ	INPUT
A list of valid codes for a specific user defined code list.
cExportBlankValues	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szDescription001	DL01	char	OPT	INPUT
A user defined name or remark.
szTypeTransaction	TYTN	char	OPT	INPUT
The qualifier used to identify a specific type of transaction.

Related Functions

None

Related Tables

None