CNT_REDCH_BEL(SQL Table) |
Index Back |
---|---|
Contract Reduced ChargesContract 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 |