RF_UTIL_AET

(SQL Table)
Index Back

Utilization Report State Rcd

State Record for Utilization Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE 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