PTIATESTCALCOPT

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIATRESHLDVAL Number(10,0) DECIMAL(10) NOT NULL Threshold Value

Default Value: 1

2 PTIACALCSTARTTIME DateTime(26) TIMESTAMP Start Time
3 PTIACALCSTOPTIME DateTime(26) TIMESTAMP Stop Time
4 PTIAIMPTCALCOPTION Number(3,0) SMALLINT NOT NULL Calculation Option
5 PTIAINCCALCCRIT1 Number(3,0) SMALLINT NOT NULL Include Criteria 1

Default Value: 1

6 PTIAINCCALCCRIT2 Number(3,0) SMALLINT NOT NULL Include Criteria 2

Default Value: 1

7 PTIAINCCALCCRIT3 Number(3,0) SMALLINT NOT NULL Include Criteria 3

Default Value: 1

8 PTIAINCCALCCRIT4 Number(3,0) SMALLINT NOT NULL Include Criteria 4

Default Value: 1

9 PTIADIRTYFLAG Character(1) VARCHAR2(1) NOT NULL Dirty Flag
10 PTIATESTINCMOFLAG Character(1) VARCHAR2(1) NOT NULL Include Flag

Y/N Table Edit