VC_PAYFORMULA_IDEFFDTDefault Value: %date
SEQNO(=(
)=)
*=*
+=+
-=-
/=/
F=Rec.Field
R=Rate Code
V=Constant
Prompt Table: COMP_RATECD_TBL
Prompt Table: VC_VALREC_VW
Prompt Table: VC_NUMFLD_VW
VC_PAYFORM_DEF(SQL Table) |
Index Back |
|---|---|
VC Calculated Field Seq RulesThis record contains the components of a calculated field formula, ordered by sequence number |
| # | 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 |
Effective Date
Default Value: %date |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | OPERAND | Character(1) | VARCHAR2(1) NOT NULL |
Operand
(=( )=) *=* +=+ -=- /=/ F=Rec.Field R=Rate Code V=Constant |
| 5 | VALUE_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Value |
| 6 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: COMP_RATECD_TBL |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: VC_VALREC_VW |
| 8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: VC_NUMFLD_VW |