BN_RTTYP_KEY (SQL Table)	Index Back
Benefit Rate Type Keys This table holds the keys defined for a Rate Type. Each key also has a "Matching Operator" to tell the system how to compare values when accessing the Rate Table data.

BN_RTTYP_KEY

(SQL Table)

Benefit Rate Type Keys

This table holds the keys defined for a Rate Type. Each key also has a "Matching Operator" to tell the system how to compare values when accessing the Rate Table data.

Parent record: BN_RATE_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RATE_TYPE Character(4) VARCHAR2(4) NOT NULL This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves.
Prompt Table: BN_RATE_TYPE

2 BN_KEY_SEQ Number(1,0) SMALLINT NOT NULL This field is used internally to sequence the keys of a benefits rate table.

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: BN_RTKEY_VW

4 BN_MATCH_OPER Character(2) VARCHAR2(2) NOT NULL This is used to specify the type of comparison operation to be used when attempting to match a value with the keys of a benefits rate table.
<=Less Than (<)
<==Less Than or Equal (<=)
==Equality (=)
>=Greater Than (>)
>==Greater Than or Equal (>=)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RATE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves. Prompt Table: BN_RATE_TYPE
2	BN_KEY_SEQ	Number(1,0)	SMALLINT NOT NULL	This field is used internally to sequence the keys of a benefits rate table.
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: BN_RTKEY_VW
4	BN_MATCH_OPER	Character(2)	VARCHAR2(2) NOT NULL	This is used to specify the type of comparison operation to be used when attempting to match a value with the keys of a benefits rate table. <=Less Than (<) <==Less Than or Equal (<=) ==Equality (=) >=Greater Than (>) >==Greater Than or Equal (>=)