PA_PROJECTIONS(SQL Table) |
Index Back |
|---|---|
ProjectionsThis is a setup table for Projections. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROJECT_METHOD |
Character(10) | VARCHAR2(10) NOT NULL | Projection Method Name |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | PROJECT_CURRENT | Character(1) | VARCHAR2(1) NOT NULL |
Current Data Treatment
I=Ignore O=User Code U=Use Default Value: U |
| 4 | PROJECT_DATA | Character(1) | VARCHAR2(1) NOT NULL |
Projection Data
C=Contributions E=Earnings H=Hours |
| 5 | PRORATE_UNITS | Character(1) | VARCHAR2(1) NOT NULL |
Proration Units
D=Days M=Months Default Value: D |
| 6 | SAME_RT_ACCRL_PD | Character(1) | VARCHAR2(1) NOT NULL |
Same Rate Accrual Period
D=Days M=Months |
| 7 | PROJECT_HOURS | Character(1) | VARCHAR2(1) NOT NULL |
Hours for Projection
A=Assumed R=Same Rate of Accrual S=Standard Hours |
| 8 | PROJECT_EARNS | Character(1) | VARCHAR2(1) NOT NULL |
Earnings for Projection
A=Assumed R=Same Rate of Accrual S=Compensation Rate |
| 9 | PROJECT_CONT | Character(1) | VARCHAR2(1) NOT NULL |
Contributions for Projection
C=Contribution Pct R=Same Rate of Accrual |