| # |
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
Y/N Table Edit
Default Value: N
|
| 6 |
OPT1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 1 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 7 |
BUS_UNIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Business Unit
Y/N Table Edit
Default Value: N
|
| 8 |
OPT2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 2 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 9 |
DEPTID_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Department ID
Y/N Table Edit
Default Value: N
|
| 10 |
OPT3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 3 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 11 |
PRODUCT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Product
Y/N Table Edit
Default Value: N
|
| 12 |
OPT4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 4 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 13 |
PROJECT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project ID
Y/N Table Edit
Default Value: N
|
| 14 |
OPT5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 5 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 15 |
TASK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Task
Y/N Table Edit
Default Value: N
|
| 16 |
OPT6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 6 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 17 |
CUSTOMER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer
Y/N Table Edit
Default Value: N
|
| 18 |
OPT7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 7 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 19 |
ACCTCD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Code
Y/N Table Edit
Default Value: N
|
| 20 |
OPT8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 21 |
RESOURCE_TYPE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Type
Y/N Table Edit
Default Value: N
|
| 22 |
OPT10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 10 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 23 |
RESOURCE_CAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Category
Y/N Table Edit
Default Value: N
|
| 24 |
OPT11 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 11 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 25 |
RESRCE_SUBCAT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resource Subcategory
Y/N Table Edit
Default Value: N
|
| 26 |
OPT12 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 12 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 27 |
ACTIVITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity
Y/N Table Edit
Default Value: N
|
| 28 |
OPT13 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 13 Option Flag
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 29 |
BUS_UNIT_HR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit HR
Y/N Table Edit
Default Value: N
|
| 30 |
OPT14 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 14 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 31 |
USER_FIELD_1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 1
Y/N Table Edit
Default Value: N
|
| 32 |
OPT15 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 15 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 33 |
USER_FIELD_2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 2
Y/N Table Edit
Default Value: N
|
| 34 |
OPT16 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 16 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 35 |
USER_FIELD_3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 3
Y/N Table Edit
Default Value: N
|
| 36 |
OPT17 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 17 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 37 |
USER_FIELD_4_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 4
Y/N Table Edit
Default Value: N
|
| 38 |
OPT18 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 18 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 39 |
USER_FIELD_5_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
User Field 5
Y/N Table Edit
Default Value: N
|
| 40 |
OPT19 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 19 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 41 |
BUS_UNIT_PF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
PF Business Unit
Y/N Table Edit
Default Value: N
|
| 42 |
OPT20 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 20 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 43 |
LOCATION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Location flag.
Y/N Table Edit
Default Value: N
|
| 44 |
OPT21 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 21 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 45 |
JOBCODE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Jobcode
Y/N Table Edit
Default Value: N
|
| 46 |
OPT22 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 22 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 47 |
POSITION_NBR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Number
Y/N Table Edit
Default Value: N
|
| 48 |
OPT23 |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 23 Use Option
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 49 |
TL_ACTIVITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
T&L Activity Flag
Y/N Table Edit
Default Value: N
|
| 50 |
OPT24 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 24
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 51 |
EP_ACTIVITY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
EP - Activity
Y/N Table Edit
Default Value: N
|
| 52 |
OPT25 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 25
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 53 |
ACCOUNT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Account
Y/N Table Edit
Default Value: N
|
| 54 |
OPT26 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 26
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 55 |
ALTACCOUNT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Account
Y/N Table Edit
Default Value: N
|
| 56 |
OPT27 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 27
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 57 |
OPERUNIT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Operating Unit
Y/N Table Edit
Default Value: N
|
| 58 |
OPT28 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 28
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 59 |
FUNDCODE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Code
Y/N Table Edit
Default Value: N
|
| 60 |
OPT29 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 29
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 61 |
GLDEPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
GL Department
Y/N Table Edit
Default Value: N
|
| 62 |
OPT30 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 30
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 63 |
PRGCODE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Code
Y/N Table Edit
Default Value: N
|
| 64 |
OPT31 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 31
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 65 |
CLASSFLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Class Field
Y/N Table Edit
Default Value: N
|
| 66 |
OPT32 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 32
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 67 |
BUDREF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Reference
Y/N Table Edit
Default Value: N
|
| 68 |
OPT33 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 33
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 69 |
AFF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Affiliate
Y/N Table Edit
Default Value: N
|
| 70 |
OPT34 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 34
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 71 |
FUNDAFF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Affiliate
Y/N Table Edit
Default Value: N
|
| 72 |
OPT35 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 35
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 73 |
OPRAFF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Operating Unit Affiliate
Y/N Table Edit
Default Value: N
|
| 74 |
OPT36 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 36
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 75 |
CF1_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield 1
Y/N Table Edit
Default Value: N
|
| 76 |
OPT37 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 37
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 77 |
CF2_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield 2
Y/N Table Edit
Default Value: N
|
| 78 |
OPT38 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 38
N=Not Used
O=Optional
R=Required
Default Value: N
|
| 79 |
CF3_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield 3
Y/N Table Edit
Default Value: N
|
| 80 |
OPT39 |
Character(1) |
VARCHAR2(1) NOT NULL |
Option 39
N=Not Used
O=Optional
R=Required
Default Value: N
|