WCS_PRORATE_IDEFFDTDefault Value: %date
D=Daily
M=Monthly
W=Weekly
Default Value: D
D=Day of Month
E=End of Month
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
WCS_PRO_EFFDT(SQL Table) |
Index Back |
|---|---|
WCS Prorate Rules EffDateThis table stores effective dated Proration Rules for use within the Workforce Compensation Solutions product area. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WCS_PRORATE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Proration Rule Identifier |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | WCS_PRORATE_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
This field defines the frequency period for the proration calculation.
D=Daily M=Monthly W=Weekly Default Value: D |
| 4 | VC_DATE_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Date Indicator
D=Day of Month E=End of Month |
| 5 | DAY_OF_MONTH | Number(2,0) | SMALLINT NOT NULL | Day of the Month |
| 6 | WCS_INCL_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Include Temporary Time
Y/N Table Edit Default Value: N |
| 7 | WCS_INCL_PART | Character(1) | VARCHAR2(1) NOT NULL |
Include Part Time
Y/N Table Edit Default Value: N |
| 8 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 9 | WCS_USE_LAST_HIRE | Character(1) | VARCHAR2(1) NOT NULL |
Last Hire Date
Y/N Table Edit Default Value: Y |
| 10 | WCS_USE_LAST_INCR | Character(1) | VARCHAR2(1) NOT NULL |
Last Increase Date
Y/N Table Edit Default Value: N |