CNT_REDCH_BEL

(SQL Table)
Index Back

Contract Reduced Charges

Contract Reduced Charges

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 RED_CHRG_CAT_BEL Character(6) VARCHAR2(6) NOT NULL Reduced Charges Category

Prompt Table: REDUCT_TBL_BEL

5 REDCH_STARTDT_BEL Date(10) DATE NOT NULL Reduced Charges Start Date
6 REDCH_ORIGIN_BEL Character(3) VARCHAR2(3) NOT NULL Reduced Charges Origin
001=National Employment Office
002=Public Centre of SocialWelfare
003=SocialSecurity Fund-SelfEmplyd
004=Acknowledged Student
005=Former Temporary Worker
7 REDCH_ENDDT_BEL Date(10) DATE Reduce Charge End Date
8 REDCH_MEASURE_BEL Character(3) VARCHAR2(3) NOT NULL Reduced Charges Employment Measurement
002=Approved Flow/Posn/SINE
004=Third employment circuit
005=PRIME program
010=Starter Agreement, Art.27.1
011=Starter Agreement, Art.27.2
012=Starter Agreement, Art.27.3
013=Disabled Starter, Art.27.1
014=Disabled Starter, Art.27.2
015=Disabled Starter, Art.27.3
016=Foreign Starter, Art.27.1
017=Foreign Starter, Art.27.2
018=Foreign Starter, Art.27.3