PKG_BSE_CMP_TBL(SQL Table) |
Index Back |
---|---|
Packaging Component TableSalary Packaging - Component Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPONENT | Character(8) | VARCHAR2(8) NOT NULL | Sal package - Package Component |
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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
6 | COMPONENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Sal Package - Component Type
AMT=Flat Amount FAIR=Airline FBRD=Board FENT=Tax-exempt Body Entertainment FEXP=Expenses FHSG=Housing FLAA=Living Away From Home Allowanc FLOA=Loan FPRK=Car Parking FPTY=Property FRSD=Residual FVEH=Motor Vehicle FWVR=Debt Waiver HOM=Home Office Lease PCT=Pct of Contributing Components PCTB=Percentage of Benefits Base Default Value: AMT |
7 | CALC_STARTING_PT | Character(1) | VARCHAR2(1) NOT NULL |
Sal package
N=None T=Total Package Value Default Value: N |
8 | PACKAGE_LEVEL | Character(3) | VARCHAR2(3) NOT NULL |
Sal Package - Package Level
NIL=No Effect TEC=Total Empl Cost TPV=Total Pkg Value Default Value: TPV |
9 | COMP_RATECD | Character(6) | VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table: PKG_COMP_RCD_VW |
10 | ADD_GROSS | Character(1) | VARCHAR2(1) NOT NULL |
Add to Gross Pay
N=No Y=Yes Y/N Table Edit Default Value: N |
11 | PROJECTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Sal Package - Projection Calculation Type
A=Ad Hoc B=Budget R=Regular Default Value: R |
12 | ENROL_BENEF_BASE | Character(1) | VARCHAR2(1) NOT NULL |
Sal Package - Enrol Benefits Base
Y/N Table Edit |
13 | BEN_BSE_COMPRATECD | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Base Comp Rate Code
Prompt Table: PKG_COMP_RCD_VW |