LE_ITEM_IDPTAI_DEP_ITEM_IDPrompt Table: PTAI_ITEM
FF=Finish to Finish
FS=Finish To Start
SF=Start to Finish
SS=Start to Start
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
W3EB_LE_DEPEND(SQL Table) |
Index Back |
|---|---|
Action Item dependentsAction Item dependents for an action item |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LE_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Item ID |
| 2 | PTAI_DEP_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Dependent Action Item ID |
| 3 | PTAI_SEQ | Number(4,0) | SMALLINT NOT NULL | Sequence |
| 4 | PTAI_LABEL | Character(100) | VARCHAR2(100) NOT NULL |
Action Items - Label
Prompt Table: PTAI_ITEM |
| 5 | 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 |
| 6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |