WM_REPORT_SETUP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | WM_MONTH_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL |
Monthly Calendar
Prompt Table:
CAL_DETL_VW
|
| 3 | WM_QTR_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL |
Quarterly Calendar
Prompt Table:
PC_CAL_SUMM_VW
|
| 4 | WM_YEARLY_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL |
Yearly Calendar
Prompt Table:
PC_CAL_SUMM_VW
|
| 5 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 6 | LASTUPDDTTM | DateTime(26) | TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Datetime |