PA_DFN_BRK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEFINITION_NAME	Character(10)	VARCHAR2(10) NOT NULL	VARCHAR2(10) NOT NULL
2	SVC_DFN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	For future use B=Break Definition S=Service Definition Type Default Value: B
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	EXCL_SVC_CD	Character(1)	VARCHAR2(1) NOT NULL	Service Exclusion Indicator
5	EXCLUDE_PRIOR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field Type for Exclude Prior D=Date Constant V=Vary by Employee
6	EXCL_SVC_B4_DT	Date(10)	DATE	Exclude service before date
7	EXCL_SVC_B4_ALS	Character(10)	VARCHAR2(10) NOT NULL	Exclude service b4 alias date Prompt Table: PA_ALIAS_USE
8	XCL_SVC_B4_ALS_TYP	Character(2)	VARCHAR2(2) NOT NULL	Exclude service b4 alias type
9	EXCLUDE_AFTER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field Type for Exclude After D=Date Constant V=Vary by Employee
10	EXCL_SVC_AFT_DT	Date(10)	DATE	Exclude service after date
11	EXCL_SVC_AFT_ALS	Character(10)	VARCHAR2(10) NOT NULL	Exclude service after alias dt Prompt Table: PA_ALIAS_USE
12	X_SVC_AFT_ALS_TYP	Character(2)	VARCHAR2(2) NOT NULL	Exclude svc after alias dt typ
13	SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Sevice type 1=Service Request 2=Service Reply C=Hours Counting E=Elapsed Time H=Hours Equivalence T=Hours and Time Dependent
14	COMPUTATION_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Computation Period A=Anniversary Year M=Calendar Month P=Plan Year Y=Calendar Year Default Value: Y
15	INIT_COMP_ANNIVYR	Character(1)	VARCHAR2(1) NOT NULL	First Period is Anniv Year Y/N Table Edit Default Value: N
16	HRS_CONSOLIDATION	Character(10)	VARCHAR2(10) NOT NULL	Hours Consolidation Name Prompt Table: PA_CONS_HRS
17	CONTRIB_CODE	Character(1)	VARCHAR2(1) NOT NULL	05/22/03 Lee - ICE 51596000 Correct spelling of Service Y/N Table Edit Default Value: N
18	CONTRIB_NAME	Character(10)	VARCHAR2(10) NOT NULL	Contrib History Name Prompt Table: PA_CONS_DED
19	DT_RND_ORD_NUM	Number(1,0)	SMALLINT NOT NULL	Date round order number
20	ADD_TIME_ORD_NUM	Number(1,0)	SMALLINT NOT NULL	Add time order number
21	FUT_ADJ_ORD_NUM	Number(1,0)	SMALLINT NOT NULL	Future adjustment order number
22	CUR_FUT_PROJ_MTHD	Character(10)	VARCHAR2(10) NOT NULL	Current/Future Projection Mthd Prompt Table: PA_PROJECTIONS
23	EQUIV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Hours Equivalence Type C=Custom D=DOL Standard U=User Code Default Value: D
24	HRS_TIM_TYP	Character(1)	VARCHAR2(1) NOT NULL	Hours && Time Type H=Hours/Time - Hours Dependent N=Hours/Time - No dependencies T=Hours/Time - Time Dependent
25	HRS_RQRMT_AMT	Number(4,0)	SMALLINT NOT NULL	Hrs/Time - Hrs Requirement Amt
26	TIME_RQRMT_AMT	Number(3,0)	SMALLINT NOT NULL	Hrs/Time- Time Requirement Amt
27	CONSEC_TIME_TYP	Character(1)	VARCHAR2(1) NOT NULL	Consecutive Time- Months/Years M=Consecutive Months Y=Consecutive Years
28	DOL_STANDARD	Character(1)	VARCHAR2(1) NOT NULL	DOL Standard Rules F=45 Hours / Week N=95 Hours / Semi-Month O=190 Hours / Month T=10 Hours / Day Default Value: T
29	EQUIV_PERIOD_CD	Character(1)	VARCHAR2(1) NOT NULL	Customized Equivalence Rules D=Day M=Month S=Semi-Month U=User Code W=Week Default Value: D
30	EQUIV_PERIOD	Number(5,0)	INTEGER NOT NULL	Custom Hours
31	DATE_OPTION	Character(10)	VARCHAR2(10) NOT NULL	Duration Option
32	PRORATE_PREV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data to be Prorated H=Hours S=Service U=User Code Default Value: S
33	PRORATE_PREV_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Counting Units for Proration D=Days E=Equivalent Periods M=Months U=User Code W=Weeks Default Value: D
34	PRORATE_CUR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data to be Prorated H=Hours S=Service U=User Code Default Value: S
35	PRORATE_CUR_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Counting Units for Proration D=Days E=Equivalent Periods M=Months U=User Code W=Weeks Default Value: D
36	ELAPSED_TIME_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Time of Elapsed Time Service D=Decimal Date Subtraction P=Count Periods R=Raw Date Subtraction
37	ELAP_TIME_DU_OPT	Character(10)	VARCHAR2(10) NOT NULL	Elapsed Time Duration Option Prompt Table: PA_DURATION_OPT
38	FNL_SVC_RSLT_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Final Service Result Unit Code M=Months Y=Years
39	FNL_RSLT_DU_OPT	Character(10)	VARCHAR2(10) NOT NULL	Final Rslt Dec Cnvrsn Opt Prompt Table: PA_DURATION_OPT
40	FNL_ADD_SVC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Final Add Service Type
41	FNL_ADD_SVC_NUM	Number(3,0)	SMALLINT NOT NULL	Final Add Service Amount
42	FNL_ADD_SVC_ALS_NM	Character(10)	VARCHAR2(10) NOT NULL	FINAL ADD SVC ALIAS NAME Prompt Table: PA_ALIAS_USE
43	FNL_ADD_SVC_ALS_TY	Character(2)	VARCHAR2(2) NOT NULL	FINAL ADD SVC ALIAS TYPE
44	FNL_SUB_SVC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Final Subtract Service Type
45	FNL_SUB_SVC_NUM	Number(3,0)	SMALLINT NOT NULL	Final Subtract Service Amount
46	FNL_SUB_SVC_ALS_NM	Character(10)	VARCHAR2(10) NOT NULL	FINAL SVC SUBTRACT ALIAS NAME Prompt Table: PA_ALIAS_USE
47	FNL_SUB_SVC_ALS_TY	Character(2)	VARCHAR2(2) NOT NULL	FINAL SVC SUB ALIAS TYPE
48	FNL_MIN_SVC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Final Minimum Service Type
49	FNL_MIN_SVC_NUM	Number(3,0)	SMALLINT NOT NULL	Final Minimum Service Amount
50	FNL_MIN_SVC_ALS_NM	Character(10)	VARCHAR2(10) NOT NULL	FINAL MIN SVC ALIAS NAME Prompt Table: PA_ALIAS_USE
51	FNL_MIN_SVC_ALS_TY	Character(2)	VARCHAR2(2) NOT NULL	FINAL MIN SVC ALIAS TYPE
52	FNL_MAX_SVC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Final Maximum Service Type
53	FNL_MAX_SVC_NUM	Number(3,0)	SMALLINT NOT NULL	Final Maximum Service Amount
54	FNL_MAX_SVC_ALS_NM	Character(10)	VARCHAR2(10) NOT NULL	FINAL MAX SERVICE AMT ALIAS NM Prompt Table: PA_ALIAS_USE
55	FNL_MAX_SVC_ALS_TY	Character(2)	VARCHAR2(2) NOT NULL	FINAL MAX SVC ALIAS TYPE
56	BRK_1YR_WAIT_YN	Character(1)	VARCHAR2(1) NOT NULL	One year wait code (y/n) Y/N Table Edit Default Value: N
57	BRK_SVC_RSTR_CD	Character(1)	VARCHAR2(1) NOT NULL	Service restoration rule code C=Count Breaks L=Always Lose Service R=Always Restore Service U=User Code Default Value: C
58	BRK_1YR_WAIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	One year wait type E=Elapsed Time U=User Code Default Value: E
59	BRK_1YR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	One year break type E=Elapsed Time H=Hours Threshold U=User Code Default Value: E
60	BRK_1YR_HRS_NUM	Number(4,0)	SMALLINT NOT NULL	1 yr break hours threshold
61	BRK_RQRMT_NUM	Number(3,0)	SMALLINT NOT NULL	# Breaks Needed to Lose Svc
62	BRK_PRI_SVC_MIN_YN	Character(1)	VARCHAR2(1) NOT NULL	Use Rule of Parity Y/N Table Edit Default Value: N
63	BRK_RSTR_VSTD_YN	Character(1)	VARCHAR2(1) NOT NULL	Restore Service if Vested Y/N Table Edit Default Value: N
64	BRK_WAIT_ELAP_CD	Character(1)	VARCHAR2(1) NOT NULL	Elapsed time wait unit code D=Days per Year M=Months U=User Code Default Value: D
65	BRK_WAIT_ASS_DAY	Number(3,0)	SMALLINT NOT NULL	# days/yr
66	BRK_ELAP_PRD_CD	Character(1)	VARCHAR2(1) NOT NULL	Elapsed time year C=Calendar Year H=Hire Anniversary Year P=Plan Year T=Term Anniversary Year Default Value: H
67	BRK_ELAP_UNIT_CD	Character(1)	VARCHAR2(1) NOT NULL	Elapsed time counting period D=Days per Year M=Months U=User Code Default Value: M
68	BRK_ELP_DU_OPT	Character(10)	VARCHAR2(10) NOT NULL	Break Id for Elapsed Time Prompt Table: PA_DURATION_OPT
69	BRK_SVC_FR	Character(10)	VARCHAR2(10) NOT NULL	Service Function Result Prompt Table: PA_DFN_SVC_VW