This page (revision-32) was last changed on 04-Jan-2023 15:27 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
32 04-Jan-2023 15:27 3 KB Kevin Higgs to previous
31 03-Jan-2023 14:04 3 KB Kevin Higgs to previous | to last
30 15-Jun-2022 11:25 3 KB Kevin Higgs to previous | to last
29 26-Nov-2021 10:22 3 KB Kevin Higgs to previous | to last USER DEFINED COLUMN ==> USER DEFINED COLUMN (UDC)
28 26-Nov-2021 10:22 3 KB khiggs to previous | to last
27 26-Nov-2021 10:22 3 KB khiggs to previous | to last
26 26-Nov-2021 10:22 3 KB rforbes to previous | to last
25 26-Nov-2021 10:22 3 KB khiggs to previous | to last
24 26-Nov-2021 10:22 3 KB khiggs to previous | to last
23 26-Nov-2021 10:22 3 KB rforbes to previous | to last
22 26-Nov-2021 10:22 3 KB rforbes to previous | to last
21 26-Nov-2021 10:22 3 KB rforbes to previous | to last

Page References

Incoming links Outgoing links
USER DEFINED COLUMN (UDC)
USER DEFINED COLUMN (UDC)

Version management

Difference between version and

At line 13 changed one line
!Steps to Set up a new User Defined Column
!!Steps to Set up a new User Defined Column
At line 16 added one line
! A. In Personality
At line 17 changed 5 lines
# Create the new column on the table. In SQL*Plus as the P2K user:
#* Add the column to the database\\{{ALTER TABLE P2K_xx_xxxxxx ADD (''COLUMN_NAME COLUMN_TYPE'');
#** where ''xx_xxxxxx'' is the table name
#** where ''COLUMN_NAME'' is the new column name
#** where ''COLUMN_TYPE'' is the data type of the new column: DATE, NUMBER, NUMBER(10,4), VARCHAR2(30), etc.\\Sample:\\{{ALTER TABLE P2K_HR_ASSIGNMENT_DETAILS ADD (ANNIVERSARY_MONTH VARCHAR2(16));}}
# In IMCD form – add the new column with a [column usage|COLUMN_USAGE] of “User Defined Column”. Ensure that [Data Type|DATA_TYPE], [Domain Name|DOMAIN_NAME] and [Length|VALUE_LENGTH] are all entered at a minimum. Review other columns for samples, as needed.
# Exit from the Personality system
! B. In the Database
In SQL*Plus as the P2K user:
# Set up the session audit information
#*Create session audits:\\ {{BEGIN\\P2K_PMSESSION.LOGIN('SQ','Modifying code in the database - put name here');\\DBMS_SESSION.SET_ROLE(p2k_pmsec.smsr(user));\\END;\\/}}
# Add the column to the database\\{{ALTER TABLE P2K_xx_xxxxxx ADD (''COLUMN_NAME COLUMN_TYPE'');
#* where ''xx_xxxxxx'' is the table name
#* where ''COLUMN_NAME'' is the new column name
#* where ''COLUMN_TYPE'' is the data type of the new column: DATE, NUMBER, NUMBER(10,4), VARCHAR2(30), etc.\\Sample:\\{{ALTER TABLE P2K_HR_ASSIGNMENT_DETAILS ADD (ANNIVERSARY_MONTH VARCHAR2(16));}}
At line 24 removed 3 lines
# Sign into the eP system
# In IMCD form – add the new column with a [column usage|COLUMN_USAGE] of “User Defined Column”. Ensure that [Data Type|DATA_TYPE], [Domain Name|DOMAIN_NAME] and [Length|VALUE_LENGTH] are all entered at a minimum. Review other columns for samples, as needed.
# Exit from the eP system
At line 28 changed 9 lines
#* {{BEGIN\\
P2K_PMSESSION.LOGIN('SQ','Modifying code in the database - put name here');\\
DBMS_SESSION.SET_ROLE(p2k_pmsec.smsr(user));\\
END;\\
/\\
#* {{@SEED_CREATE_BIUD.pls}}
#* {{@DB_RECOMPILE.sql}}
#* You may now exit SQL*Plus
#*\\{{@SEED_CREATE_BIUD.pls\\@DB_RECOMPILE.sql\\}}
You may now exit SQL*Plus
! C. Restart the application
This page (revision-32) was last changed on 04-Jan-2023 15:27 by Kevin HiggsTop