PROCESS_INSTANCEB=Biweekly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
N=No
Y=Yes
B=Billable
I=Internal
P=Personal
U=Nonbillable
FC_PREPOP_AET(SQL Table) |
Index Back |
|---|---|
Populate Forecast State RecordForecast Population State Record |
| # | 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 | WORK_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Count of Anything |
| 5 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | FORECAST_HORIZON | Number(3,0) | SMALLINT NOT NULL | Forecast Horizon |
| 9 | FORECAST_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Frequency
B=Biweekly M=Monthly Q=Quarterly S=Semimonthly W=Weekly |
| 10 | END_DAY_OF_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Ending Day of Period
1=Sunday 2=Monday 3=Tuesday 4=Wednesday 5=Thursday 6=Friday 7=Saturday |
| 11 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 12 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 13 | SELECT_ALL_OPT | Character(1) | VARCHAR2(1) NOT NULL | Select All |
| 14 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 15 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 16 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 17 | RS | Character(1) | VARCHAR2(1) NOT NULL | Resource Management |
| 18 | LOAD_RM | Character(1) | VARCHAR2(1) NOT NULL | Load Resource Management Data |
| 19 | LOAD_PRIOR_FC | Character(1) | VARCHAR2(1) NOT NULL | Load From Prior Forecast |
| 20 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 21 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 22 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 23 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 24 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 25 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 26 | BILLING_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action
B=Billable I=Internal P=Personal U=Nonbillable |
| 27 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 28 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 29 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 30 | FIELD_ID | Character(24) | VARCHAR2(24) NOT NULL | Config Field Id |
| 31 | DIFFERENCE_HR | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Difference |
| 32 | RM | Character(1) | VARCHAR2(1) NOT NULL | Risk Management |
| 33 | WHERE_LONG | Long Character | CLOB | Where Clause |