AP_DB_DSC_PS_VW(SQL View) |
Index Back |
|---|---|
Discounts Pers - CFO Portal |
| SELECT A.OPRID , B.CALENDAR_ID_AP , A.YEAR , A.PERIOD_AP2 , ' ' FROM %Table(AP_DB_DSC_PERS2) A , %Table(AP_DB_DSC_PERS) B WHERE A.OPRID = B.OPRID |
| # | 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: OPR_DEF_TBL_FS.OPRID |
| 2 | CALENDAR_ID_AP |
Character(1) | VARCHAR2(1) NOT NULL |
Calendar ID
A=Annually M=Monthly Q=Quarterly Default Value: M |
| 3 | YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Year
1=NONE |
| 4 | 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 |
| 5 | PERIOD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Period Name |