PTAFAW_TXN_LBL - Approval Transaction Levels - PeopleTools Table Reference

PTAFAW_TXN_LBL	index back
Approval Transaction Levels

Defines the approval levels the transaction supports. Some application transactions only support Header level.

PeopleSoft Field Name Field Type Column Type Description
PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
PTAFLEVEL Number(1,0) SMALLINT NOT NULL Level e.g. Header = 0, Line = 1.
0=Header
1=Line
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
Prompt Table: PTAFFLD_LBL_VW
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19

PeopleSoft Field Name	Field Type	Column Type	Description
PTAFPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
PTAFLEVEL	Number(1,0)	SMALLINT NOT NULL	Level e.g. Header = 0, Line = 1. 0=Header 1=Line
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN
FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG. Prompt Table: PTAFFLD_LBL_VW