GetSDBDataItemTitle

SDB Data Item Information

Minor Business Rule

Object Name: N0800028

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

This NER contains two helper functions:

GetSDBDataItemTitle()
This function is called by Supplemental Data Multiskill Search (P080250) to retrieve the data item title (from F00091) for a supplemental database data
type.  A blank title is returned if the data item title cannot be found.  The data structure elements SY and RT are not used by this function.

SetUp Notes

Technical Specifications

Parameters

Data Item Data Structure DescriptionI/O      Required     Table   Notes
SDB        Supplemental Database CodeIY
MSDT    Type Data                              IY
MSDI       Multiskill Search Data Item                IYKY, RMK, RMK2, AMTU, AMTV, EFT, or
                                                                                             FTE
DL01       Description                            Oreturned by GetSDBDataItemTitle()
SY           System Code                         Oreturned by GetSDBDataItemUDC()
RT           User Defined Code               Oreturned by GetSDBDataItemUDC()

Related Tables

Table Table Description
F00091Supplemental Database Data Types

Processing

GetSDBDataItemTitle():

Read the F00091 record for the supplemental database data type.
Return the associated title for the given data item.

^

Data Structure

DN0800028 - SDB Data Item Information

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSupplementalDatabaseCode	SDB	char	NONE	NONE
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.
szTypeDta	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szDescription001	DL01	char	NONE	NONE
A user defined name or remark.
szSystemCode	SY	char	NONE	NONE
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	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.

Related Functions

None

Related Tables

None

GetSDBDataItemUDC

SDB Data Item Information

Minor Business Rule

Object Name: N0800028

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

This NER contains two helper functions:

GetSDBDataItemUDC()
This function is also called by P080250 to retrieve the system and udc codes for a supplemental database data type.  A blank system and udc code is
returned if the data item system and udc codes cannot be found.  The data structure element DL01 is not used by this function.

SetUp Notes

Technical Specifications

Parameters

Data Item Data Structure DescriptionI/ORequiredTableNotes
SDB        Supplemental Database CodeIY
MSDT    Type Data                              IY
MSDI      Multiskill Search Data Item                IY                KY, RMK, RMK2, AMTU, AMTV,
                                                                                                              EFT, or EFTE
DL01                       Description                                O              returned by GetSDBDataItemTitle()
SY           System Code                         O                 returned by GetSDBDataItemUDC()
RT           User Defined Code               O                  returned by GetSDBDataItemUDC()

Related Tables

Table Table Description
F00091Supplemental Database Data Types

Processing

GetSDBDataItemUDC():

Read the F00091 record for the supplemental database data type.
Return the associated system and udc codes for the given data item.
^

Data Structure

DN0800028 - SDB Data Item Information

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSupplementalDatabaseCode	SDB	char	NONE	NONE
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.
szTypeDta	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szDescription001	DL01	char	NONE	NONE
A user defined name or remark.
szSystemCode	SY	char	NONE	NONE
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	NONE	NONE
A code that identifies the table that contains user defined codes. The table is also referred to as a UDC type.

Related Functions

None

Related Tables

None