UPG_TL_REC008(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | UPG_ROWID | Number(3,0) | SMALLINT NOT NULL | UPG_ROW_ID |
2 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
6 | ALLOCATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Allocation Type
C=Allocation by Percentage E=Allocation Equally All Tasks H=Allocation by Quantity |
7 | SEND_TO_TCD | Character(1) | VARCHAR2(1) NOT NULL | Send To TCD |
8 | TASK_PRFL_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Template ID |
9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
10 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |