PT_ACCHELP (SQL Table)	Index Back
Accessibility Help Topic Table

PT_ACCHELP

(SQL Table)

Accessibility Help Topic Table

Related Language Record: PT_ACCHELP_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PT_ACCHELP_CODE Character(30) VARCHAR2(30) NOT NULL Help Code

2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

3 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
Default Value: A

4 PT_ACCHELP_LABEL Character(80) VARCHAR2(80) NOT NULL Help Label

5 PT_ACCHELP_CONT Long Character CLOB NOT NULL Topic Content

6 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime

7 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID

8 LAST_UPDATE_DTTM 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.

9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PT_ACCHELP_CODE	Character(30)	VARCHAR2(30) NOT NULL	Help Code
2	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
3	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
4	PT_ACCHELP_LABEL	Character(80)	VARCHAR2(80) NOT NULL	Help Label
5	PT_ACCHELP_CONT	Long Character	CLOB NOT NULL	Topic Content
6	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Datetime
7	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
8	LAST_UPDATE_DTTM	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.
9	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.