PKG_RULE_CMP(SQL Table) |
Index Back |
|---|---|
Salary Package Rule Detail TblSalary Packaging - Rule Detail Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PKG_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Sal Package - Package Rule ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %DATE |
| 3 | COMPONENT |
Character(8) | VARCHAR2(8) NOT NULL |
Sal package - Package Component
Prompt Table: PKG_BSE_CMP_TBL |
| 4 | COMPONENT_SEQ |
Number(3,0) | SMALLINT NOT NULL | Component Sequence Number - Salary Packaging |
| 5 | CMP_COMPONENT | Character(8) | VARCHAR2(8) NOT NULL |
Sal Package - Comparing Component
CMP=Component Value TEC=Total Empl Cost TPV=Total Pkg Value Default Value: CMP |
| 6 | BOOLEAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Sal Package - rule comparison
<=Less Than <==Less or Equal >=Greater Than >==Greater or Equal To Default Value: > |
| 7 | CMP_VALUE | Number(16,2) | DECIMAL(15,2) NOT NULL | Sal Package - Comparison Value |
| 8 | AMT_OR_PCT | Character(1) | VARCHAR2(1) NOT NULL |
Sal Package - Amount of Percentage Flag
A=Amount P=Percent Default Value: P |
| 9 | PKG_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag - Salary Packaging
Y/N Table Edit Default Value: N |