BN_RATE_KEYS (SQL Table)	Index Back
Benefit Rate Keys This table holds the key sources available for use in Rate Type definitions. This table is maintained as internal PeopleSoft system data and has no component to manage it.

BN_RATE_KEYS

(SQL Table)

Benefit Rate Keys

This table holds the key sources available for use in Rate Type definitions. This table is maintained as internal PeopleSoft system data and has no component to manage it.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BN_FIELDNAME_ALIAS Character(18) VARCHAR2(18) NOT NULL This field is used internally to define an alias for a standard fieldname. The alias facilitates aspects of grid configurability.

3 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

4 BN_USES_COMPENSATN Character(1) VARCHAR2(1) NOT NULL This is used to indicate whether a benefit rate table either acts upon compensation (such as a percent of salary rate) or requires compensation as a key (such as compensation-banded rate tables).
Y/N Table Edit
Default Value: N

5 BN_USES_DEMOGRPHCS Character(1) VARCHAR2(1) NOT NULL This is used to indicate whether a benefit rate table requires individual demographics as a key (such as age, gender, smoker status, covered-person type).
Y/N Table Edit
Default Value: N

6 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSDBFIELD
2	BN_FIELDNAME_ALIAS	Character(18)	VARCHAR2(18) NOT NULL	This field is used internally to define an alias for a standard fieldname. The alias facilitates aspects of grid configurability.
3	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
4	BN_USES_COMPENSATN	Character(1)	VARCHAR2(1) NOT NULL	This is used to indicate whether a benefit rate table either acts upon compensation (such as a percent of salary rate) or requires compensation as a key (such as compensation-banded rate tables). Y/N Table Edit Default Value: N
5	BN_USES_DEMOGRPHCS	Character(1)	VARCHAR2(1) NOT NULL	This is used to indicate whether a benefit rate table requires individual demographics as a key (such as age, gender, smoker status, covered-person type). Y/N Table Edit Default Value: N
6	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: Y