BEN_BI_CALENDAR (SQL Table)	Index Back
Billing Calendar BEN_BI_CALENDAR describes the billing periods. It contains start and end date information and comments for billing statements.

BEN_BI_CALENDAR

(SQL Table)

Billing Calendar

BEN_BI_CALENDAR describes the billing periods. It contains start and end date information and comments for billing statements.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BILL_PER_CD Character(4) VARCHAR2(4) NOT NULL Billing Period

2 PERIOD_BEGIN_DT Date(10) DATE NOT NULL Period Begin Date

3 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date

4 BILL_DUE Date(10) DATE NOT NULL Payment Due

5 COBRA_DUE Date(10) DATE NOT NULL COBRA Payment Due

6 COMMENTS Long Character CLOB Comment

7 BILL_CALC_RUN Character(1) VARCHAR2(1) NOT NULL Billing Calculation Run
Default Value: N

8 BILL_STATEMENT_RUN Character(1) VARCHAR2(1) NOT NULL Billing Statements Printed
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BILL_PER_CD	Character(4)	VARCHAR2(4) NOT NULL	Billing Period
2	PERIOD_BEGIN_DT	Date(10)	DATE NOT NULL	Period Begin Date
3	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date
4	BILL_DUE	Date(10)	DATE NOT NULL	Payment Due
5	COBRA_DUE	Date(10)	DATE NOT NULL	COBRA Payment Due
6	COMMENTS	Long Character	CLOB	Comment
7	BILL_CALC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Billing Calculation Run Default Value: N
8	BILL_STATEMENT_RUN	Character(1)	VARCHAR2(1) NOT NULL	Billing Statements Printed Default Value: N