OPRIDDefault Value: AP_DB_DSC_PERS.OPRID
YEAR1=NONE
PERIOD_AP201=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
Q1=1st Quarter
Q2=2nd Quarter
Q3=3rd Quarter
Q4=4th Quarter
AP_DB_DSC_PERS2(SQL Table) |
Index Back |
|---|---|
Discounts Pers - CFO Portal |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: AP_DB_DSC_PERS.OPRID |
| 2 | YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Year
1=NONE |
| 3 | PERIOD_AP2 |
Character(2) | VARCHAR2(2) NOT NULL |
Period
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December Q1=1st Quarter Q2=2nd Quarter Q3=3rd Quarter Q4=4th Quarter |