SDBQuery

Supplemental Data Multiskill Search

Minor Business Rule

Object Name: B0800026

Parent DLL: CHRM

Location: Client/Server

Language: C

SDBQuery
Supplemental Data Multiskill Search
Object Name: B0800026
Parent DLL: CHRM
Location: Client/Server
Language: C
Data Structure
Parameter NameData ItemData TypeReq/OptI/O/Both
szSupplementalDatabaseCode_1SDBcharNONENONE
szTypeDta_1MSDTcharNONENONE
szMultiskillSearchDataItem_1MSDIcharNONENONE
szRelationshipValue_1VALScharNONENONE
szMultiskillSearchData_1MSSEcharNONENONE
szAndOr1_2AOR1charNONENONE
szSupplementalDatabaseCode_2SDBcharNONENONE
szTypeDta_2MSDTcharNONENONE
szMultiskillSearchDataItem_2MSDIcharNONENONE
szRelationshipValue_2VALScharNONENONE
szMultiskillSearchData_2MSSEcharNONENONE
szAndOr1_3AOR1charNONENONE
szSupplementalDatabaseCode_3SDBcharNONENONE
szTypeDta_3MSDTcharNONENONE
szMultiskillSearchDataItem_3MSDIcharNONENONE
szRelationshipValue_3VALScharNONENONE
szMultiskillSearchData_3MSSEcharNONENONE
szAndOr1_4AOR1charNONENONE
szSupplementalDatabaseCode_4SDBcharNONENONE
szTypeDta_4MSDTcharNONENONE
szMultiskillSearchDataItem_4MSDIcharNONENONE
szRelationshipValue_4VALScharNONENONE
szMultiskillSearchData_4MSSEcharNONENONE
szAndOr1_5AOR1charNONENONE
szSupplementalDatabaseCode_5SDBcharNONENONE
szTypeDta_5MSDTcharNONENONE
szMultiskillSearchDataItem_5MSDIcharNONENONE
szRelationshipValue_5VALScharNONENONE
szMultiskillSearchData_5MSSEcharNONENONE
szAndOr1_6AOR1charNONENONE
szSupplementalDatabaseCode_6SDBcharNONENONE
szTypeDta_6MSDTcharNONENONE
szMultiskillSearchDataItem_6MSDIcharNONENONE
szRelationshipValue_6VALScharNONENONE
szMultiskillSearchData_6MSSEcharNONENONE
szAndOr1_7AOR1charNONENONE
szSupplementalDatabaseCode_7SDBcharNONENONE
szTypeDta_7MSDTcharNONENONE
szMultiskillSearchDataItem_7MSDIcharNONENONE
szRelationshipValue_7VALScharNONENONE
szMultiskillSearchData_7MSSEcharNONENONE
szAndOr1_8AOR1charNONENONE
szSupplementalDatabaseCode_8SDBcharNONENONE
szTypeDta_8MSDTcharNONENONE
szMultiskillSearchDataItem_8MSDIcharNONENONE
szRelationshipValue_8VALScharNONENONE
szMultiskillSearchData_8MSSEcharNONENONE
Related Functions
None
Related Tables
F00092 Supplemental Data

^

Data Structure

D0800026 - Supplemental Data Multiskill Search

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSupplementalDatabaseCode_1	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_1	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_1	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_1	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_1	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.
szAndOr1_2	AOR1	char	NONE	NONE
A code to designate whether the test parameters or criteria are based on an AND condition or an OR condition.
szSupplementalDatabaseCode_2	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_2	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_2	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_2	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_2	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.
szAndOr1_3	AOR1	char	NONE	NONE
A code to designate whether the test parameters or criteria are based on an AND condition or an OR condition.
szSupplementalDatabaseCode_3	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_3	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_3	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_3	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_3	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.
szAndOr1_4	AOR1	char	NONE	NONE
A code to designate whether the test parameters or criteria are based on an AND condition or an OR condition.
szSupplementalDatabaseCode_4	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_4	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_4	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_4	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_4	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.
szAndOr1_5	AOR1	char	NONE	NONE
A code to designate whether the test parameters or criteria are based on an AND condition or an OR condition.
szSupplementalDatabaseCode_5	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_5	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_5	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_5	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_5	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.
szAndOr1_6	AOR1	char	NONE	NONE
A code to designate whether the test parameters or criteria are based on an AND condition or an OR condition.
szSupplementalDatabaseCode_6	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_6	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_6	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_6	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_6	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.
szAndOr1_7	AOR1	char	NONE	NONE
A code to designate whether the test parameters or criteria are based on an AND condition or an OR condition.
szSupplementalDatabaseCode_7	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_7	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_7	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_7	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_7	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.
szAndOr1_8	AOR1	char	NONE	NONE
A code to designate whether the test parameters or criteria are based on an AND condition or an OR condition.
szSupplementalDatabaseCode_8	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_8	MSDT	char	NONE	NONE
The type of data from the supplemental database that the system uses in a multiple information search.
szMultiskillSearchDataItem_8	MSDI	char	NONE	NONE
Indicates which data item within the data type is to be included in the multiskill search.
szRelationshipValue_8	VALS	char	NONE	NONE
A code that identifies the operands in Boolean logic. You can specify any of the following codes: EQ Equal to LT Less than LE Less than or equal to GT Greater than GE Greater than or equal to NE Not equal to NL Not less than NG Not greater than
szMultiskillSearchData_8	MSSE	char	NONE	NONE
A value that the system uses to search for supplemental employee data. To obtain desired results, enter a search value that is based on the data you entered in the profile for the selected field. NOTE: This value is case sensitive. For example, you want to search for the word Active. If the data was originally entered into the database as Active, then you must enter the value into the search field as Active. Do not enter ACTIVE or active. You can also use the % wildcard character to search for data that starts, ends, or contains one or more consecutive characters. The following are examples that use the % wildcard character: o BA%: displays bamboo and bachelor. o %ing: displays all words ending with ing. o %BA%: displays all words containing the letters B and A, such as abate, cabbage, or bachelor.

Related Functions

N0800028 SDB Data Item Information

Related Tables

F00091 Supplemental Database Data Types
F00092 Supplemental Data