SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
PARTY_TYPE_CDEFFDTDefault Value: %date
A=Active
I=Inactive
1=Principal Contact
2=External Contact
3=Internal Administrator
4=Internal Manager
5=Internal Clerk
Default Value: 1
RE_PTY_TYPE_PRN(SQL View) |
Index Back |
|---|---|
Principal RolesThis defines the valid set of principal roles. |
| SELECT %subrec(RE_PTY_TYPE_PRN, A) FROM PS_RE_PTY_TYPE A WHERE ROLE_TYP = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PARTY_TYPE_CD |
Character(20) | VARCHAR2(20) NOT NULL | Party type code (Internal or External) |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Role Type Name |
| 6 | END_EFFDT | Date(10) | DATE | Ending effective date established to be used by queries to improve effective-date processing performance. |
| 7 | ROLE_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Role Category
1=Principal Contact 2=External Contact 3=Internal Administrator 4=Internal Manager 5=Internal Clerk Default Value: 1 |
| 8 | INSTANCE_DESCR | Character(150) | VARCHAR2(150) NOT NULL | Generic Description Field for Instances of Generic Entities |