UX_APPR_PLT_CFG (SQL Table)	Index Back
Approvals Pagelet Config This record contains the configuration options for the dashboard approvals pagelet.

UX_APPR_PLT_CFG

(SQL Table)

Approvals Pagelet Config

This record contains the configuration options for the dashboard approvals pagelet.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 UX_APPR_MAX_NUM Number(3,0) SMALLINT NOT NULL This field stores the maximum number of approvals to display on the Pending Approvals pagelet.
Default Value: 10

2 UX_APPR_WARNDT_TYP Character(1) VARCHAR2(1) NOT NULL This field indicates whether the Overdue and Standard warnings are displayed based on the Transaction Effective Date or Approval Receipt Date for the Pending Approvals pagelet.
1=Approval Receipt Date
2=Transaction Effective Date
Default Value: 1

3 UX_APPR_OVRD_OPT Character(1) VARCHAR2(1) NOT NULL This field indicates whether the Overdue warning is displayed on the Pending Approvals pagelet.
Y/N Table Edit
Default Value: N

4 UX_APPR_NUM_DAYS1 Number(2,0) SMALLINT NOT NULL This field stores the number of days before the transaction effective date or after the approval receipt date to display the Overdue warning on the Pending Approvals pagelet.

5 UX_APPR_STD_OPT Character(1) VARCHAR2(1) NOT NULL This field indicates whether the Standard warning is displayed on the Pending Approvals pagelet.
Y/N Table Edit
Default Value: N

6 UX_APPR_NUM_DAYS2 Number(2,0) SMALLINT NOT NULL This field stores the number of days before the transaction effective date or after the approval receipt date to display the Standard warning on the Pending Approvals pagelet.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	UX_APPR_MAX_NUM	Number(3,0)	SMALLINT NOT NULL	This field stores the maximum number of approvals to display on the Pending Approvals pagelet. Default Value: 10
2	UX_APPR_WARNDT_TYP	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the Overdue and Standard warnings are displayed based on the Transaction Effective Date or Approval Receipt Date for the Pending Approvals pagelet. 1=Approval Receipt Date 2=Transaction Effective Date Default Value: 1
3	UX_APPR_OVRD_OPT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the Overdue warning is displayed on the Pending Approvals pagelet. Y/N Table Edit Default Value: N
4	UX_APPR_NUM_DAYS1	Number(2,0)	SMALLINT NOT NULL	This field stores the number of days before the transaction effective date or after the approval receipt date to display the Overdue warning on the Pending Approvals pagelet.
5	UX_APPR_STD_OPT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether the Standard warning is displayed on the Pending Approvals pagelet. Y/N Table Edit Default Value: N
6	UX_APPR_NUM_DAYS2	Number(2,0)	SMALLINT NOT NULL	This field stores the number of days before the transaction effective date or after the approval receipt date to display the Standard warning on the Pending Approvals pagelet.