EMPLIDPrompt Table: PEOPLE_SRCH
Default Value: %date
A=Active
I=Inactive
Default Value: A
Default Value: NI
NAMEPrompt Table: PEOPLE_SRCH
Y/N Table Edit
Default Value: N
RELATION_SMY_VW(SQL View) |
Index Back |
|---|---|
Relationships ViewRelationships View contains all fields in the Relationships table. |
| SELECT A.EMPLID , A.RELATIONSHIP_NBR , A.EFFDT , A.EFF_STATUS , A.PEOPLE_RELATION , A.NAME , A.EMPLID_RELATED , A.JOINT_RECORD FROM PS_RELATIONSHIPS A WHERE A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_RELATIONSHIPS X WHERE X.EMPLID = A.EMPLID AND X.RELATIONSHIP_NBR = A.RELATIONSHIP_NBR AND X.EFFDT <= %CurrentDateIn) AND EFF_STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | RELATIONSHIP_NBR | Number(2,0) | SMALLINT NOT NULL | Relationship Nbr |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | PEOPLE_RELATION | Character(2) | VARCHAR2(2) NOT NULL |
Relationship
Default Value: NI |
| 6 | NAME |
Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL |
Related People ID
Prompt Table: PEOPLE_SRCH |
| 8 | JOINT_RECORD | Character(1) | VARCHAR2(1) NOT NULL |
Create Joint Records
Y/N Table Edit Default Value: N |