VC_PAYFORMULA_IDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: VC_PAYFORM_TBL.DESCR50
Default Value: N
D=Round Down
S=Standard Rounding
U=Round Up
VC_PAYFORM_TBL(SQL Table) |
Index Back |
|---|---|
Variable Comp Formula TableThis record describes various calculated field formulas used in Variable Compensation as well as some calculation rules. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VC_PAYFORMULA_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payout Formula ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: VC_PAYFORM_TBL.DESCR50 |
| 6 | RATE_CODE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Is Rate Code Overridable?
Default Value: N |
| 7 | VC_ROUND_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Rounding Rule
D=Round Down S=Standard Rounding U=Round Up |
| 8 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
| 9 | VC_PAYFORMULA_SQL | Character(254) | VARCHAR2(254) NOT NULL | Pay Formula SQL |