SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
PLAN_TMPL_IDEVENT_OCCURRENCEDefault Value: 1
1=Date
2=Milestone
Default Value: 1
A=Project
C=Contract
Prompt Table: CA_MS_DEFN
D=Days
M=Months
Y=Years
Default Value: M
CA_PLAN_TMPL_EV(SQL Table) |
Index Back |
|---|---|
Plan Event TempalatesPlan Event Tempalates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PLAN_TMPL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Plan Template ID |
| 3 | EVENT_OCCURRENCE |
Number(3,0) | SMALLINT NOT NULL |
Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
Default Value: 1 |
| 4 | CA_EVENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Contracts Event Type
1=Date 2=Milestone Default Value: 1 |
| 5 | MILESTONE_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Milestone Origin
A=Project C=Contract |
| 6 | MILESTONE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
Prompt Table: CA_MS_DEFN |
| 7 | ADD_TO_BASIS | Number(3,0) | SMALLINT NOT NULL | Add To Basis |
| 8 | ADD_TO_BASIS_UOM | Character(1) | VARCHAR2(1) NOT NULL |
Add to Basis Date UOM
D=Days M=Months Y=Years Default Value: M |
| 9 | DAYS_LAG | Number(3,0) | SMALLINT NOT NULL | A number of days lag before an activity/event occurs. |
| 10 | CA_PERCENTAGE | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Percentage |