PTAI_ITEM_IDPTAI_PARENT_ACTIOND=Dependency
S=Summary/Details
FF=Finish to Finish
FS=Finish To Start
SF=Start to Finish
SS=Start to Start
Default Value: FS
N=Display Inactive Lists
Y=Display Active Lists
Default Value: Y
PTAI_HIER(SQL Table) |
Index Back |
|---|---|
AI Hierarchy |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 2 | PTAI_PARENT_ACTION |
Character(31) | VARCHAR2(31) NOT NULL | Controller Action |
| 3 | PTAI_RELATION | Character(1) | VARCHAR2(1) NOT NULL |
Relation Type
D=Dependency S=Summary/Details |
| 4 | PTAI_RULE | Character(2) | VARCHAR2(2) NOT NULL |
Rule
FF=Finish to Finish FS=Finish To Start SF=Start to Finish SS=Start to Start Default Value: FS |
| 5 | PTAI_ACTIVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Action Item Active Flag
N=Display Inactive Lists Y=Display Active Lists Default Value: Y |