| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TASK_PRFL_TMPLT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Task Template ID
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_TSKPRF_TMPLT.DESCR
|
| 4 |
COMMIT_ACCTG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Accounting
Y/N Table Edit
Default Value: N
|
| 5 |
COMPANY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Company
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 6 |
BUS_UNIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether Business Unit (PC) is to be included as a Task or Time Reporting Element
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 7 |
DEPTID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Department ID
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 8 |
PRODUCT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
TL Product
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 9 |
PROJECT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project ID
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 10 |
TASK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 11 |
CUSTOMER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 12 |
ACCTCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Combination Code
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 13 |
RESOURCE_TYPE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Type
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 14 |
RESOURCE_CAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Category
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 15 |
RESRCE_SUBCAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Subcategory
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 16 |
ACTIVITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity
N=Not Used
O=o
R=r
Default Value: N
|
| 17 |
BUS_UNIT_HR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit HR
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 18 |
USER_FIELD_1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 1
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 19 |
USER_FIELD_2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 2
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 20 |
USER_FIELD_3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 3
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 21 |
USER_FIELD_4_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 4
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 22 |
USER_FIELD_5_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 5
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 23 |
BUS_UNIT_PF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit PF
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 24 |
LOCATION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Location flag.
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 25 |
JOBCODE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Jobcode
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 26 |
POSITION_NBR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Number
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 27 |
TL_ACTIVITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
T&L Activity Flag
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 28 |
EP_ACTIVITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether FS Activity is to be included on Task Template and Time Reporting
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 29 |
TL_PROJECT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
TL Project Flag
N=Not Used
O=Optional
R=Required
Default Value: N
|