PA_DURATION(SQL Table) |
Index Back |
---|---|
Date DurationsThis 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 |