PSPTFPCLOUDPVDR (SQL Table)	Index Back
File Attachment Cloud Provider Stores the Configuration of configured Personal cloud Storage providers.

PSPTFPCLOUDPVDR

(SQL Table)

File Attachment Cloud Provider

Stores the Configuration of configured Personal cloud Storage providers.

Related Language Record: PSPTFPCLOUDLANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTFPOAUTH2_CLNTNAM Character(60) VARCHAR2(60) NOT NULL Provider Name

2 PTFP_USE_OAUTH Character(1) VARCHAR2(1) NOT NULL Use OAuth2 style configuration or not
N=No
Y=Yes
Default Value: Y

3 PTFPCLOUDPVDRLABEL Character(15) VARCHAR2(15) NOT NULL Label of Cloud Provider to display with icon

4 PTFPOAUTH2_DESCR Character(254) VARCHAR2(254) NOT NULL Icon Tooltip

5 PTFPSHOWCLOUD Character(1) VARCHAR2(1) NOT NULL Display Option for Cloud Providers
A=PC and Android
D=PC Only
F=All
I=PC and iOS
Default Value: I

6 PTFPOAUTH2_CLNT_ID Character(254) VARCHAR2(254) NOT NULL Client ID

7 PTFPOAUTH2_CLNTSEC Character(254) VARCHAR2(254) NOT NULL Client Secret

8 PTFPOAUTH2_RED_URI Character(254) VARCHAR2(254) NOT NULL Redirect URI

9 PTFPOAUTH2_SCOPE Character(254) VARCHAR2(254) NOT NULL Application Scope

10 PTFPJS_LIB_URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

11 PTFPFUNCNAME Character(254) VARCHAR2(254) NOT NULL Function Name

12 PTFPOVERRIDE_FUNC Character(1) VARCHAR2(1) NOT NULL Override Function
N=No
Y=Yes
Default Value: N

13 PTFPCUSTOM_JS Long Character CLOB Custom JavaScript

14 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

15 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 0

16 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.

17 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTFPOAUTH2_CLNTNAM	Character(60)	VARCHAR2(60) NOT NULL	Provider Name
2	PTFP_USE_OAUTH	Character(1)	VARCHAR2(1) NOT NULL	Use OAuth2 style configuration or not N=No Y=Yes Default Value: Y
3	PTFPCLOUDPVDRLABEL	Character(15)	VARCHAR2(15) NOT NULL	Label of Cloud Provider to display with icon
4	PTFPOAUTH2_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Icon Tooltip
5	PTFPSHOWCLOUD	Character(1)	VARCHAR2(1) NOT NULL	Display Option for Cloud Providers A=PC and Android D=PC Only F=All I=PC and iOS Default Value: I
6	PTFPOAUTH2_CLNT_ID	Character(254)	VARCHAR2(254) NOT NULL	Client ID
7	PTFPOAUTH2_CLNTSEC	Character(254)	VARCHAR2(254) NOT NULL	Client Secret
8	PTFPOAUTH2_RED_URI	Character(254)	VARCHAR2(254) NOT NULL	Redirect URI
9	PTFPOAUTH2_SCOPE	Character(254)	VARCHAR2(254) NOT NULL	Application Scope
10	PTFPJS_LIB_URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
11	PTFPFUNCNAME	Character(254)	VARCHAR2(254) NOT NULL	Function Name
12	PTFPOVERRIDE_FUNC	Character(1)	VARCHAR2(1) NOT NULL	Override Function N=No Y=Yes Default Value: N
13	PTFPCUSTOM_JS	Long Character	CLOB	Custom JavaScript
14	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
15	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
16	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.
17	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.