RESULT_NAMEA=Alias Name
D=Date Constant
Default Value: A
Prompt Table: PA_ALIAS_USE
A=Alias Name
D=Date Constant
Default Value: A
Prompt Table: PA_ALIAS_USE
Prompt Table: PA_DURATION_OPT
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 |
From Date Alias
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 |