RS_AGG_AEP(SQL Table) |
Index Back |
---|---|
Utilization App Engine Control |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | RS_BU_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit
A=All HR Business Units S=Specify U=User Preferences |
4 | NUMBER_PERIODS_RS | Number(3,0) | SMALLINT NOT NULL |
No. of Past Periods
01=01 02=02 03=03 04=04 05=05 06=06 07=07 08=08 09=09 10=10 11=11 12=12 |
5 | NUMBER_PERIODS_RS2 | Number(3,0) | SMALLINT NOT NULL |
No. of Future Periods
01=01 02=02 03=03 04=04 05=05 06=06 07=07 08=08 09=09 10=10 11=11 12=12 |
6 | RS_CAL_UTILIZATION | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Utilization
Y/N Table Edit Default Value: N |
7 | RS_CAL_CAPACITY | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Capacity
Y/N Table Edit Default Value: N |