HR_OBD_INSTALL

(SQL Table)
Index Back

OnBoarding Installation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

Prompt Table: AGC_CAT_TBL

2 HR_OBD_TMPL_OPT Character(1) VARCHAR2(1) NOT NULL Template Assignment
D=Use Default Template
T=Use Template Assignment

Default Value: D

3 AGC_TMA_ID Character(20) VARCHAR2(20) NOT NULL Activity Guide Composer Template Assignement Id

Prompt Table: HR_OBD_CFG_TAVW

4 AGC_TEMPLATE_ID Character(7) VARCHAR2(7) NOT NULL Activity Guide Composer Template Id

Prompt Table: HR_OBD_CFG_TCVW

5 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

Prompt Table: PSURLDEFN

6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: PSROLEDEFN

7 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name

Prompt Table: WL_TEMPLATE_GEN

8 HR_OBD_EM_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Reminder Template

Prompt Table: WL_TEMPLATE_GEN

9 ALLOW_COMPLETE Character(1) VARCHAR2(1) NOT NULL Allow Complete

Y/N Table Edit

Default Value: N

10 ALLOW_DELETE Character(1) VARCHAR2(1) NOT NULL Allow Delete

Y/N Table Edit

Default Value: N

11 HR_OBD_ADD_USR_PRF Character(1) VARCHAR2(1) NOT NULL Add User Profile

Y/N Table Edit

Default Value: N

12 HR_OBD_OPRID Character(30) VARCHAR2(30) NOT NULL User ID to use as the base for assigning permission list and roles to new user profile for an OnBoarding person.

Prompt Table: PSOPRDEFN_VW

13 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Package Name

Prompt Table: HR_OBD_PCKG_VW

14 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path

Prompt Table: HR_OBD_PATH_VW

15 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: HR_OBD_CLASS_VW

16 HR_OBD_UP_METHOD Character(1) VARCHAR2(1) NOT NULL Method to be used: C - CreateUserProfile G - GetUserProfileParameters
C=CreateUserProfile
G=GetUserProfileParameters