RF_UTIL_AET(SQL Table) |
Index Back |
|---|---|
Utilization Report State RcdState Record for Utilization Report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | UUID_RAW | Character(36) | VARCHAR2(36) NOT NULL | Universal Unique Identifier - can be used as an identifier when processing a batch of data. |
| 5 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 6 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 7 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
C=C N=N Y=Y |
| 8 | DAYS_SUNDAY | Number(3,0) | SMALLINT NOT NULL | Number of Sundays in a date range. |
| 9 | DAYS_MONDAY | Number(3,0) | SMALLINT NOT NULL | Number of Mondays in a date range. |
| 10 | DAYS_TUESDAY | Number(3,0) | SMALLINT NOT NULL | Number of Tuesdays in a date range |
| 11 | DAYS_WEDNESDAY | Number(3,0) | SMALLINT NOT NULL | Number of Wednesdays in a date range |
| 12 | DAYS_THURSDAY | Number(3,0) | SMALLINT NOT NULL | Number of Thursdays in a date range. |
| 13 | DAYS_FRIDAY | Number(3,0) | SMALLINT NOT NULL | Number of Fridays in a date range. |
| 14 | DAYS_SATURDAY | Number(3,0) | SMALLINT NOT NULL | Number of Saturdays in a date range. |
| 15 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 16 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |