RUN_CNTL_BEN (SQL Table)	Index Back
Run Control for Benefits This record is used for batch processing and defines the parameters required by the batch system to run benefits. Important -- this record also used to run batch processes from the On Demand Event Maintenance component. If the record structure is changed, then review function ONDM_RUN_SQR_REPORT() in PeopleCode BENEF_PB_WRK.ODEM_SCHED_ACTY_PB.FldDef to verify whether the Record.Insert() is impacted.

RUN_CNTL_BEN

(SQL Table)

Run Control for Benefits

This record is used for batch processing and defines the parameters required by the batch system to run benefits. Important -- this record also used to run batch processes from the On Demand Event Maintenance component. If the record structure is changed, then review function ONDM_RUN_SQR_REPORT() in PeopleCode BENEF_PB_WRK.ODEM_SCHED_ACTY_PB.FldDef to verify whether the Record.Insert() is impacted.

Parent Record Of RUNCTL_BEN_PLAN RUN_CNTL_BEN_CO RUN_CNTL_BEN_PT RUN_CNTL_BEN_VD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 ASOFDATE Date(10) DATE As of Date

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 FROMDATE Date(10) DATE From Date

6 THRUDATE Date(10) DATE End Date

7 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
Prompt Table: PAY_FORM_TBL

8 NDT_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL NDT Report Type
K=401(k) Report Test Type
M=401(m) Report Test Type

9 NDT_TEST_TYPE Character(1) VARCHAR2(1) NOT NULL NDT Test Type
1=Standard NDT
2=Section 129 NDT
3=Section 129 NDT by SLOB

10 REPRINT_PROMPT Character(1) VARCHAR2(1) NOT NULL Reprint
Y/N Table Edit

11 REPORTING_PERIOD Character(1) VARCHAR2(1) NOT NULL Reporting Period
M=Monthly
Q=Quarterly

12 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

13 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_PROV_VW

14 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

15 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID
Prompt Table: BAS_SCHED

16 PRINT_ID Character(6) VARCHAR2(6) NOT NULL Print ID
Prompt Table: %RECNAME_EDIT

17 COST_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Cost Freq on Enrollment Form
A=Annual Frequency
D=Deduction Frequency
Default Value: D

18 INCL_OPTN_DETAIL Character(1) VARCHAR2(1) NOT NULL Include Option Detail
Y/N Table Edit
Default Value: N

19 BAS_FORM_TYPE Character(1) VARCHAR2(1) NOT NULL Benefits Admin Form Type
C=Confirmation Statement
E=Enrollment Form

20 FORM_DATE Date(10) DATE Benefits Admin Form Date
Default Value: %date

21 PROCESS_STATUS_AE Character(1) VARCHAR2(1) NOT NULL Assign Error
Y/N Table Edit
Default Value: N

22 PROCESS_STATUS_AN Character(1) VARCHAR2(1) NOT NULL Assign None
Y/N Table Edit
Default Value: N

23 PROCESS_STATUS_AS Character(1) VARCHAR2(1) NOT NULL Assigned
Y/N Table Edit
Default Value: N

24 PROCESS_STATUS_EE Character(1) VARCHAR2(1) NOT NULL Election Error
Y/N Table Edit
Default Value: N

25 PROCESS_STATUS_ET Character(1) VARCHAR2(1) NOT NULL Elections Entered
Y/N Table Edit
Default Value: N

26 PROCESS_STATUS_FA Character(1) VARCHAR2(1) NOT NULL Finalized - Benefit Pgm None
Y/N Table Edit
Default Value: N

27 PROCESS_STATUS_FE Character(1) VARCHAR2(1) NOT NULL Finalized - Enrolled
Y/N Table Edit
Default Value: N

28 PROCESS_STATUS_FP Character(1) VARCHAR2(1) NOT NULL Finalized - Prepare None
Y/N Table Edit
Default Value: N

29 PROCESS_STATUS_NT Character(1) VARCHAR2(1) NOT NULL Notified
Y/N Table Edit
Default Value: N

30 PROCESS_STATUS_PE Character(1) VARCHAR2(1) NOT NULL Prepare Error
Y/N Table Edit
Default Value: N

31 PROCESS_STATUS_PR Character(1) VARCHAR2(1) NOT NULL Prepared
Y/N Table Edit
Default Value: N

32 PROCESS_STATUS_RE Character(1) VARCHAR2(1) NOT NULL Re-Enter
Y/N Table Edit
Default Value: N

33 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: %EDITTABLE

34 CURR_EFFDT Date(10) DATE Current Benefit Program Effdt
Prompt Table: BEN_DEFN_PGM_VW

35 NEW_BENPROGRAM Character(3) VARCHAR2(3) NOT NULL New Benefit Program

36 NEW_EFFDT Date(10) DATE New Benefit Program Effdt

37 ELIG_RULES_ID Character(4) VARCHAR2(4) NOT NULL Eligibility Rules ID
Prompt Table: BAS_ELIG_RULES

38 EVENT_RULES_ID Character(4) VARCHAR2(4) NOT NULL Event Rules ID
Prompt Table: BAS_EVENT_RULES

39 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

40 CHECK_DT Date(10) DATE Check date.

41 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.

42 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: %EDITTABLE

43 CLAIMID Character(8) VARCHAR2(8) NOT NULL Claim ID

44 FSA_ACCT_CLOSURE Character(1) VARCHAR2(1) NOT NULL FSA Account Closre
Y/N Table Edit
Default Value: N

45 FMLA_PLAN_ID Character(3) VARCHAR2(3) NOT NULL Family Medical Leave Plan ID
Prompt Table: FMLA_PLAN_TBL

46 FMLA_RPTG_WEEKS Number(2,0) SMALLINT NOT NULL Leaves Completed Report Weeks

47 RPT_DETAIL_LEVEL Character(1) VARCHAR2(1) NOT NULL Level of Report Detail
C=Claim-Level Detail
D=Line-Item Detail Level
R=Summary by Selection
S=Detail Report

48 BILL_PER_CD Character(4) VARCHAR2(4) NOT NULL Billing Period
Prompt Table: BEN_BI_CALENDAR

49 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
Prompt Table: BAS_PAR_CONFBVW

50 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification
Prompt Table: BAS_PAR_CONFEVW

51 ADDR_ELIG_CHG Character(1) VARCHAR2(1) NOT NULL Address Eligibility Changed
Y/N Table Edit
Default Value: N

52 MJ_ELIG_CHG Character(1) VARCHAR2(1) NOT NULL Flag to indicate that a change to the Primary_Jobs table was detected for this employee, which may have an impact on eligibility already processed for this event.
Y/N Table Edit
Default Value: N

53 JOB_ELIG_CHG Character(1) VARCHAR2(1) NOT NULL Job Eligibility Changed
Y/N Table Edit
Default Value: N

54 BAS_EVT_DISCONNECT Character(1) VARCHAR2(1) NOT NULL Event Disconnected
Y/N Table Edit
Default Value: N

55 BAS_EVENT_CHG Character(1) VARCHAR2(1) NOT NULL Event Out of Sequence
Y/N Table Edit
Default Value: N

56 INCL_SUMMARY Character(1) VARCHAR2(1) NOT NULL Include Summary
Y/N Table Edit
Default Value: N

57 INCLUDE_1X Character(1) VARCHAR2(1) NOT NULL Health
Y/N Table Edit
Default Value: Y

58 INCLUDE_2X Character(1) VARCHAR2(1) NOT NULL Life
Y/N Table Edit
Default Value: Y

59 INCLUDE_4X Character(1) VARCHAR2(1) NOT NULL Savings
Y/N Table Edit
Default Value: Y

60 INCLUDE_8X Character(1) VARCHAR2(1) NOT NULL Pension
Y/N Table Edit
Default Value: Y

61 AUDIT_TYPE_ME Character(1) VARCHAR2(1) NOT NULL Missing Elections
Y/N Table Edit
Default Value: Y

62 AUDIT_TYPE_UI Character(1) VARCHAR2(1) NOT NULL Uncovered Individuals
Y/N Table Edit
Default Value: Y

63 AUDIT_TYPE_SA Character(1) VARCHAR2(1) NOT NULL Spousal Allocation
Y/N Table Edit
Default Value: Y

64 TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
Prompt Table: PSRECDEFN

65 TABLE_NAME1 Character(30) VARCHAR2(30) NOT NULL Table Name

66 BEN500_RUN_OPTION Character(1) VARCHAR2(1) NOT NULL Run Option
1=All Employess in the Database
2=Employees Specified in List
3=Employees in a PS Table
4=Employees in a non-PS Table
Default Value: 2

67 DESCR Character(30) VARCHAR2(30) NOT NULL Description

68 END_DATE Date(10) DATE End Date

69 BN_EDI_PARTNER_ID Character(15) VARCHAR2(15) NOT NULL Identification of Trading Partner for the Benefits EDI transactions.
Prompt Table: BN_EDI_PARTNERS

70 BN_ACTION_CODE Character(2) VARCHAR2(2) NOT NULL File Type Code is stored in this field. Values used are as follows: 2- Update Only File 4- Full File Audit RX- Full File Replacement. Used as a drop down on Create HIPAA EDI file page.
2=Update Only File
4=Full File Audit
RX=Full File Replacement

71 BN_ACK_REQUESTED Character(1) VARCHAR2(1) NOT NULL Acknowledgement Request Indicator, used as a checkbox on Create HIPAA EDI file page.
Default Value: 0

72 BN_USAGE_IND Character(1) VARCHAR2(1) NOT NULL Benefits Usage Indicator, stores whether a file is Production or Test File. Used as a checkbox on Create HIPAA EDI File page.
P=Production File
T=Test File
Default Value: P

73 BN_834_FL_EFFDT Date(10) DATE Stores File Effective Date for HIPAA EDI File

74 BN_834_FL_ENRLDT Date(10) DATE Stores File Enrollment Date for HIPAA EDI File

75 BN_834_ALL_VD_FLG Character(1) VARCHAR2(1) NOT NULL Flag that allows the selection of all vendors represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file.
Y/N Table Edit
Default Value: N

76 BN_834_ALL_CO_FLG Character(1) VARCHAR2(1) NOT NULL Flag that allows the selection of all companies represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file.
Y/N Table Edit
Default Value: N

77 BN_834_ALL_PT_FLG Character(1) VARCHAR2(1) NOT NULL Flag that allows the selection of all plan types represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file.
Y/N Table Edit
Default Value: N

78 BN_834_ALL_PLANS Character(1) VARCHAR2(1) NOT NULL Include all Benefit Plans
Y/N Table Edit
Default Value: N

79 BN_834_ALL_GRPNBR Character(1) VARCHAR2(1) NOT NULL Include all Group Numbers
Y/N Table Edit
Default Value: N

80 BN_834_MAX_MEMBERS Number(5,0) INTEGER NOT NULL Stores the maximum number of members to be included in each transaction set on the HIPAA 834 EDI file.
Default Value: 10000

81 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
Default Value: M
Prompt Table: BEN_FREQ_VW

82 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

83 BN_TOGGLE Character(1) VARCHAR2(1) NOT NULL This is a "dummy" field used only to force PeopleTools save processing in a component. We have several pages that contain enterable fields only for derived/work records, yet we need Tools to fire SaveXXX events. The only way to make this happen is to change a field value on a "real" database record in the component. This field is used as a dummy field on a real record, whose value is toggled between "Y" and "N" in order to force Tools save processing.

84 USE_RUNTIME_DATE Character(1) VARCHAR2(1) NOT NULL Use Runtime Date
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	ASOFDATE	Date(10)	DATE	As of Date
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	FROMDATE	Date(10)	DATE	From Date
6	THRUDATE	Date(10)	DATE	End Date
7	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification Prompt Table: PAY_FORM_TBL
8	NDT_REPORT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	NDT Report Type K=401(k) Report Test Type M=401(m) Report Test Type
9	NDT_TEST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	NDT Test Type 1=Standard NDT 2=Section 129 NDT 3=Section 129 NDT by SLOB
10	REPRINT_PROMPT	Character(1)	VARCHAR2(1) NOT NULL	Reprint Y/N Table Edit
11	REPORTING_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Reporting Period M=Monthly Q=Quarterly
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
13	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_PROV_VW
14	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
15	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID Prompt Table: BAS_SCHED
16	PRINT_ID	Character(6)	VARCHAR2(6) NOT NULL	Print ID Prompt Table: %RECNAME_EDIT
17	COST_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Cost Freq on Enrollment Form A=Annual Frequency D=Deduction Frequency Default Value: D
18	INCL_OPTN_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	Include Option Detail Y/N Table Edit Default Value: N
19	BAS_FORM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Benefits Admin Form Type C=Confirmation Statement E=Enrollment Form
20	FORM_DATE	Date(10)	DATE	Benefits Admin Form Date Default Value: %date
21	PROCESS_STATUS_AE	Character(1)	VARCHAR2(1) NOT NULL	Assign Error Y/N Table Edit Default Value: N
22	PROCESS_STATUS_AN	Character(1)	VARCHAR2(1) NOT NULL	Assign None Y/N Table Edit Default Value: N
23	PROCESS_STATUS_AS	Character(1)	VARCHAR2(1) NOT NULL	Assigned Y/N Table Edit Default Value: N
24	PROCESS_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	Election Error Y/N Table Edit Default Value: N
25	PROCESS_STATUS_ET	Character(1)	VARCHAR2(1) NOT NULL	Elections Entered Y/N Table Edit Default Value: N
26	PROCESS_STATUS_FA	Character(1)	VARCHAR2(1) NOT NULL	Finalized - Benefit Pgm None Y/N Table Edit Default Value: N
27	PROCESS_STATUS_FE	Character(1)	VARCHAR2(1) NOT NULL	Finalized - Enrolled Y/N Table Edit Default Value: N
28	PROCESS_STATUS_FP	Character(1)	VARCHAR2(1) NOT NULL	Finalized - Prepare None Y/N Table Edit Default Value: N
29	PROCESS_STATUS_NT	Character(1)	VARCHAR2(1) NOT NULL	Notified Y/N Table Edit Default Value: N
30	PROCESS_STATUS_PE	Character(1)	VARCHAR2(1) NOT NULL	Prepare Error Y/N Table Edit Default Value: N
31	PROCESS_STATUS_PR	Character(1)	VARCHAR2(1) NOT NULL	Prepared Y/N Table Edit Default Value: N
32	PROCESS_STATUS_RE	Character(1)	VARCHAR2(1) NOT NULL	Re-Enter Y/N Table Edit Default Value: N
33	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules. Prompt Table: %EDITTABLE
34	CURR_EFFDT	Date(10)	DATE	Current Benefit Program Effdt Prompt Table: BEN_DEFN_PGM_VW
35	NEW_BENPROGRAM	Character(3)	VARCHAR2(3) NOT NULL	New Benefit Program
36	NEW_EFFDT	Date(10)	DATE	New Benefit Program Effdt
37	ELIG_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Eligibility Rules ID Prompt Table: BAS_ELIG_RULES
38	EVENT_RULES_ID	Character(4)	VARCHAR2(4) NOT NULL	Event Rules ID Prompt Table: BAS_EVENT_RULES
39	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
40	CHECK_DT	Date(10)	DATE	Check date.
41	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
42	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: %EDITTABLE
43	CLAIMID	Character(8)	VARCHAR2(8) NOT NULL	Claim ID
44	FSA_ACCT_CLOSURE	Character(1)	VARCHAR2(1) NOT NULL	FSA Account Closre Y/N Table Edit Default Value: N
45	FMLA_PLAN_ID	Character(3)	VARCHAR2(3) NOT NULL	Family Medical Leave Plan ID Prompt Table: FMLA_PLAN_TBL
46	FMLA_RPTG_WEEKS	Number(2,0)	SMALLINT NOT NULL	Leaves Completed Report Weeks
47	RPT_DETAIL_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Level of Report Detail C=Claim-Level Detail D=Line-Item Detail Level R=Summary by Selection S=Detail Report
48	BILL_PER_CD	Character(4)	VARCHAR2(4) NOT NULL	Billing Period Prompt Table: BEN_BI_CALENDAR
49	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number. Prompt Table: BAS_PAR_CONFBVW
50	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification Prompt Table: BAS_PAR_CONFEVW
51	ADDR_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Address Eligibility Changed Y/N Table Edit Default Value: N
52	MJ_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate that a change to the Primary_Jobs table was detected for this employee, which may have an impact on eligibility already processed for this event. Y/N Table Edit Default Value: N
53	JOB_ELIG_CHG	Character(1)	VARCHAR2(1) NOT NULL	Job Eligibility Changed Y/N Table Edit Default Value: N
54	BAS_EVT_DISCONNECT	Character(1)	VARCHAR2(1) NOT NULL	Event Disconnected Y/N Table Edit Default Value: N
55	BAS_EVENT_CHG	Character(1)	VARCHAR2(1) NOT NULL	Event Out of Sequence Y/N Table Edit Default Value: N
56	INCL_SUMMARY	Character(1)	VARCHAR2(1) NOT NULL	Include Summary Y/N Table Edit Default Value: N
57	INCLUDE_1X	Character(1)	VARCHAR2(1) NOT NULL	Health Y/N Table Edit Default Value: Y
58	INCLUDE_2X	Character(1)	VARCHAR2(1) NOT NULL	Life Y/N Table Edit Default Value: Y
59	INCLUDE_4X	Character(1)	VARCHAR2(1) NOT NULL	Savings Y/N Table Edit Default Value: Y
60	INCLUDE_8X	Character(1)	VARCHAR2(1) NOT NULL	Pension Y/N Table Edit Default Value: Y
61	AUDIT_TYPE_ME	Character(1)	VARCHAR2(1) NOT NULL	Missing Elections Y/N Table Edit Default Value: Y
62	AUDIT_TYPE_UI	Character(1)	VARCHAR2(1) NOT NULL	Uncovered Individuals Y/N Table Edit Default Value: Y
63	AUDIT_TYPE_SA	Character(1)	VARCHAR2(1) NOT NULL	Spousal Allocation Y/N Table Edit Default Value: Y
64	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name Prompt Table: PSRECDEFN
65	TABLE_NAME1	Character(30)	VARCHAR2(30) NOT NULL	Table Name
66	BEN500_RUN_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Run Option 1=All Employess in the Database 2=Employees Specified in List 3=Employees in a PS Table 4=Employees in a non-PS Table Default Value: 2
67	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
68	END_DATE	Date(10)	DATE	End Date
69	BN_EDI_PARTNER_ID	Character(15)	VARCHAR2(15) NOT NULL	Identification of Trading Partner for the Benefits EDI transactions. Prompt Table: BN_EDI_PARTNERS
70	BN_ACTION_CODE	Character(2)	VARCHAR2(2) NOT NULL	File Type Code is stored in this field. Values used are as follows: 2- Update Only File 4- Full File Audit RX- Full File Replacement. Used as a drop down on Create HIPAA EDI file page. 2=Update Only File 4=Full File Audit RX=Full File Replacement
71	BN_ACK_REQUESTED	Character(1)	VARCHAR2(1) NOT NULL	Acknowledgement Request Indicator, used as a checkbox on Create HIPAA EDI file page. Default Value: 0
72	BN_USAGE_IND	Character(1)	VARCHAR2(1) NOT NULL	Benefits Usage Indicator, stores whether a file is Production or Test File. Used as a checkbox on Create HIPAA EDI File page. P=Production File T=Test File Default Value: P
73	BN_834_FL_EFFDT	Date(10)	DATE	Stores File Effective Date for HIPAA EDI File
74	BN_834_FL_ENRLDT	Date(10)	DATE	Stores File Enrollment Date for HIPAA EDI File
75	BN_834_ALL_VD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag that allows the selection of all vendors represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file. Y/N Table Edit Default Value: N
76	BN_834_ALL_CO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag that allows the selection of all companies represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file. Y/N Table Edit Default Value: N
77	BN_834_ALL_PT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag that allows the selection of all plan types represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file. Y/N Table Edit Default Value: N
78	BN_834_ALL_PLANS	Character(1)	VARCHAR2(1) NOT NULL	Include all Benefit Plans Y/N Table Edit Default Value: N
79	BN_834_ALL_GRPNBR	Character(1)	VARCHAR2(1) NOT NULL	Include all Group Numbers Y/N Table Edit Default Value: N
80	BN_834_MAX_MEMBERS	Number(5,0)	INTEGER NOT NULL	Stores the maximum number of members to be included in each transaction set on the HIPAA 834 EDI file. Default Value: 10000
81	PAY_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Pay Frequency A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly Default Value: M Prompt Table: BEN_FREQ_VW
82	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
83	BN_TOGGLE	Character(1)	VARCHAR2(1) NOT NULL	This is a "dummy" field used only to force PeopleTools save processing in a component. We have several pages that contain enterable fields only for derived/work records, yet we need Tools to fire SaveXXX events. The only way to make this happen is to change a field value on a "real" database record in the component. This field is used as a dummy field on a real record, whose value is toggled between "Y" and "N" in order to force Tools save processing.
84	USE_RUNTIME_DATE	Character(1)	VARCHAR2(1) NOT NULL	Use Runtime Date Y/N Table Edit Default Value: N