PY_PFF_CALC_DTL(SQL Table) |
Index Back |
---|---|
Calculation Rule DetailsCalculation Rule Details Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PY_PFF_CALCRULE | Character(10) | VARCHAR2(10) NOT NULL | Calc Rule Id |
2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
3 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
5 | MAINT_RESPONSBLTY | Character(1) | VARCHAR2(1) NOT NULL |
Maintenance Responsibility
C=Customer P=PeopleSoft Default Value: C |
6 | PY_PFF_SLF_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
Self Adjust
M=MTD N=NA Q=QTD Y=YTD Default Value: N |
7 | PY_PFF_RULE_APL | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Basis
A=Always B=UI Jurisdiction or Resident R=Resident U=UI Jurisdiction Default Value: A |
8 | PY_PFF_ROUND_IND | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Basis
A=Two Decimals (Default) B=Three Decimals Default Value: A |
9 | DESCRLONG | Long Character | CLOB | Long Description |