SETIDACTIVITY_TYPEA=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
PROJ_STANDARDS(SQL Table) |
Index Back |
|---|---|
Project Costing Calc StandardsProject Costing Calc Standards |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ACTIVITY_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 6 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 7 | STANDARD_COST | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Standard Cost |
| 8 | STANDARD_MINUTES | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Standard Minutes |
| 9 | STANDARD_HOURS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Standard Hours |
| 10 | MARKUP_MULTIPLIER | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Markup Multiplier |