JPM_JP_TYPES_VW(SQL View) |
Index Back |
---|---|
Profile Types - SearchSearch view for Profile Types |
SELECT A.JPM_JP_TYPE , A.EFFDT , A.DESCR , A.JPM_JP_SUMMARY , A.JPM_JP_TYPE_STATUS , A.JPM_PROFILE_USAGE , A.JPM_SRCH_CTL , A.JPM_SUBSCRIBE_CTL , A.END_EFFDT , A.TRANSACTION_NAME , A.EOAWDEFN_ID , A.JPM_PID_APPRVL_FLG , A.SYSTEM_DATA_FLG FROM PS_JPM_JP_TYPES A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JPM_JP_TYPES B WHERE A.JPM_JP_TYPE = B.JPM_JP_TYPE AND B.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type | |
2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | JPM_JP_SUMMARY | Long Character | CLOB | Summary description of the Profile Type |
5 | JPM_JP_TYPE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of Job Profile Type
A=Active I=Inactive P=Pending Default Value: A |
6 | JPM_PROFILE_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Value used to specify how the profile is used in business logic. This profile may represent a person profile, a profile in progress and not available for use, a job profile, etc.
A=Administrator Only J=End / Final / Job P=Person T=Template Prompt Table: JPM_JP_USAGE_VW |
7 | JPM_SRCH_CTL | Character(1) | VARCHAR2(1) NOT NULL |
JPM Search Control field
N=Never P=Specified on Profile Y=Always Default Value: P |
8 | JPM_SUBSCRIBE_CTL | Character(1) | VARCHAR2(1) NOT NULL |
JPM Subscribe Control field
N=Never P=Specified on Profile Y=Always Default Value: P |
9 | END_EFFDT | Date(10) | DATE | End Effdt |
10 | TRANSACTION_NAME | Character(25) | VARCHAR2(25) NOT NULL |
EDI Transaction Name
Prompt Table: JPM_EO_TRANS_I |
11 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Framework Definition ID
Prompt Table: EOAW_PRCS |
12 | JPM_PID_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if Approval is required for updates to Profile Identities for Profiles of this Type.
Y/N Table Edit Default Value: N |
13 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |