PA_DURATION

(SQL Table)
Index Back

Date Durations

This is a setup table for Date Durations.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RESULT_NAME Character(10) VARCHAR2(10) NOT NULL Alias Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DATE_TO_TYPE Character(1) VARCHAR2(1) NOT NULL Date-To Field Type
A=Alias Name
D=Date Constant

Default Value: A

4 DATE_TO Date(10) DATE Previous Period Date To
5 DATE_TO_ALIAS Character(10) VARCHAR2(10) NOT NULL Date-To

Prompt Table: PA_ALIAS_USE

6 DATE_TO_ALIAST Character(2) VARCHAR2(2) NOT NULL Alias Type
7 DATE_FROM_TYPE Character(1) VARCHAR2(1) NOT NULL Date From Field Type
A=Alias Name
D=Date Constant

Default Value: A

8 DATE_FROM Date(10) DATE Date From
9 DATE_FROM_ALIAS Character(10) VARCHAR2(10) NOT NULL Date-From

Prompt Table: PA_ALIAS_USE

10 DATE_FROM_ALIAST Character(2) VARCHAR2(2) NOT NULL Alias Type
11 DATE_OPTION Character(10) VARCHAR2(10) NOT NULL Duration Option

Prompt Table: PA_DURATION_OPT