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