HR_OFB_INSTALL(SQL Table) |
Index Back |
|---|---|
OffBoarding 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 | ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type
1=By Dept Security Tree 2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID 7=By Group ID |
| 3 | HR_AG_TMPL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Template Assignment
D=Use Default Template T=Use Template Assignment Def Default Value: D |
| 4 | AGC_TMA_ID | Character(20) | VARCHAR2(20) NOT NULL |
Activity Guide Composer Template Assignement Id
Prompt Table: HR_OBD_CFG_TAVW |
| 5 | AGC_TEMPLATE_ID | Character(7) | VARCHAR2(7) NOT NULL |
Activity Guide Composer Template Id
Prompt Table: HR_OBD_CFG_TCVW |
| 6 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
| 7 | AGC_ASSIGNEE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity Guide Composer - Assignee ID
Prompt Table: AGC_CAT_ASG_VW |