R_NDT_CONTROL (SQL Table)	Index Back
Tmp Tbl-NDT Run Control R_NDT_CONTROL is a temporary record that is used to define the run parameters for Nondiscrimination testing. It sets up the parameters for earnings, calendar year, month/year codes and signed values.

R_NDT_CONTROL

(SQL Table)

Tmp Tbl-NDT Run Control

R_NDT_CONTROL is a temporary record that is used to define the run parameters for Nondiscrimination testing. It sets up the parameters for earnings, calendar year, month/year codes and signed values.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

2 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
Default Value: INSTALLATION.BAL_ID_FOR_CAL_YR
Prompt Table: BALANCE_ID_TBL

3 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
Prompt Table: BAL_YR_NO_CO_VW

4 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period
Prompt Table: BALPRD_NO_CO_VW

5 YEAR_CD Character(1) VARCHAR2(1) NOT NULL Year Code: used in Nondiscriminating Testing and...
B=Current and Prior Plan Year
C=Current Plan Year
P=Prior Plan Year

6 SIGNVALUE Signed Number(2,0) DECIMAL(1) NOT NULL Signed Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
2	BALANCE_ID	Character(2)	VARCHAR2(2) NOT NULL	Balance ID Default Value: INSTALLATION.BAL_ID_FOR_CAL_YR Prompt Table: BALANCE_ID_TBL
3	BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balances for Year Prompt Table: BAL_YR_NO_CO_VW
4	BALANCE_PERIOD	Number(3,0)	SMALLINT NOT NULL	Balances for Period Prompt Table: BALPRD_NO_CO_VW
5	YEAR_CD	Character(1)	VARCHAR2(1) NOT NULL	Year Code: used in Nondiscriminating Testing and... B=Current and Prior Plan Year C=Current Plan Year P=Prior Plan Year
6	SIGNVALUE	Signed Number(2,0)	DECIMAL(1) NOT NULL	Signed Value