FT_X_TP_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 FT_PROFILE_EP_DATA Character(1) VARCHAR2(1) NOT NULL Profile and Appraisal Data
B=Profile and Appraisal Data
P=Profile Data Only

Default Value: P

7 FT_ENABLE_RUN Character(1) VARCHAR2(1) NOT NULL Enable Run PB

Y/N Table Edit

Default Value: N

8 FT_FILE_NAME Character(254) VARCHAR2(254) NOT NULL Output Zip File Override
9 FT_CONFIG_ID Character(30) VARCHAR2(30) NOT NULL Configuration ID

Prompt Table: FT_CONFIG

10 FT_EMAIL_TO Character(254) VARCHAR2(254) NOT NULL Email Recipents
11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
13 DESCRLONG Long Character CLOB Long Description
14 EP_DESCR254 Long Character(1325) VARCHAR2(1325) 1325 character description field used in ePerformance
15 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
16 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
17 EFFDT Date(10) DATE Effective Date

Default Value: %date